error message of SET @@global.tidb_cloud_storage_uri is not clear

[lance6716]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> SET @@global.tidb_cloud_storage_uri = 's3://test/test/?provider=test';

2. What did you expect to see? (Required)

detailed error message, like the one in log

[2024/06/18 20:57:10.111 +08:00] [INFO] [conn.go:1162] ["command dispatched failed"] [conn=2097154] [session_alias=] [connInfo="id:2097154, addr:127.0.0.1:64090 status:10, collation:utf8mb4_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="SET @@global.tidb_cloud_storage_uri = 's3://test/test/?provider=test'"] [txn_mode=PESSIMISTIC] [timestamp=0] [err="[BR:ExternalStorage:ErrStorageInvalidPermission]external storage permission\ncheck permission ListObjects failed due to NoCredentialProviders: no valid providers in chain\ncaused by: EnvAccessKeyNotFound: failed to find credentials in the environment.\nSharedCredsLoad: failed to load profile, .\nEC2RoleRequestError: no EC2 instance role found\ncaused by: RequestError: send request failed\ncaused by: Get \"http://169.254.169.254/latest/meta-data/iam/security-credentials/\": context deadline exceeded (Client.Timeout exceeded while awaiting headers)

3. What did you see instead (Required)

mysql> SET @@global.tidb_cloud_storage_uri = 's3://test/test/?provider=test';
ERROR 1105 (HY000): external storage permission

4. What is your TiDB version? (Required)