Does TaurusDB Provide the Root Account or Super Permissions?

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.

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

• 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 TaurusDB 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.