Global Parameters Fail to Change on the Client

Scenario

A global parameter failed to be changed on the client, the error message "ERROR 1227 (42000): Access denied" was displayed.

Possible Causes

GaussDB(for MySQL) does not support global parameter changes using commands.

Solution

Log in to the console and modify the parameters on the console.

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
4. On the Instances page, click the instance name to go to the Basic Information page.
5. In the navigation pane, choose Parameters. On the Parameters tab, view and modify parameters.