Also needed to create CONNECT outward tables. Read and write files on the server, using statements like LOAD DATA INFILE or functions like LOAD_FILE(). Hashed password, generated by the PASSWORD() function.Ĭan execute FLUSH statements or equivalent mariadb-admin commands.Ĭan shut down the server with SHUTDOWN or mariadb-admin shutdown.Ĭan show information about active processes, via SHOW PROCESSLIST or mariadb-admin processlist.
User (together with Host makes up the unique identifier for this account.
Host (together with User makes up the unique identifier for this account. The er table contains the following fields: See privileges for a more complete view of the MariaDB privilege system. A user may not be granted create privilege at the user level, but may still have create permission on certain tables or databases, for example. Note that the MariaDB privileges occur at many levels.
#MYSQL SHOW DATABASES USERS UPDATE#
The table can be queried and although it is possible to directly update it, it is best to use GRANT and CREATE USER for adding users and privileges. The er table contains information about users that have permission to access the MariaDB server, and their global privileges. Previously, root was the definer, which resulted in privilege problems when this username was changed ( MDEV-19650). From MariaDB 10.4.13, the dedicated mariadb.sys user is created as the definer of the view. New tools are supposed to use INFORMATION_SCHEMA tables. It is now a view into mysql.global_priv created for compatibility with older applications and monitoring scripts. In MariaDB 10.4 and later, the mysql.global_priv table has replaced the er table, and er should be considered obsolete.
0 kommentar(er)
