Does TaurusDB Provide the Root Account or Super Permission?

TaurusDB 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 TaurusDB. This is a major difference between cloud databases and on-premises MySQL databases. To ensure stable running of instances, TaurusDB does not provide the super permission for the root user.

If you need to perform operations that require super permissions, TaurusDB provides alternative methods.

For example:

You can modify parameter values only on the TaurusDB 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 TaurusDB Using mysqldump.