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

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 super permissions for the root user. That's because super permissions allow you to execute management commands, such as reset master, set global, kill, and reset slave. These operations may cause unpredictable errors in GaussDB(for MySQL).

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

• 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 GaussDB(for MySQL) 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.