Does GaussDB(for MySQL) Provide the Root Account or Super Permission?

GaussDB(for MySQL) provides the administrator user root which has the permissions except super, file, shutdown, and create tablespace.

Most cloud database service platforms do not provide the super permission for the root user. The super permissions allow users to execute many management commands, such as reset master, set global, kill, and reset slave. These operations may cause unpredictable exceptions and faults for GaussDB(for MySQL). This is a major difference between cloud databases and on-premises MySQL databases. To ensure stable running of instances, GaussDB(for MySQL) does not provide the super permission for the root user.

If you need to perform actions that normally require super permissions, GaussDB(for MySQL) provides alternative methods.

For example:

You can modify parameter values only on the GaussDB(for MySQL) console. You cannot run the following command on a database to modify parameter values.

set global parameter name=Parameter value;

If the script contains the set global command, delete the set global command and modify parameter values on the console.

An error is reported after you run the following command because the root user does not have super permissions. You can delete definer='root' from the command.

create definer='root'@'%' trigger(procedure)...

You can import and export data using mysqldump. For details, see Migrating Data to GaussDB(for MySQL) Using mysqldump.