Difference between revisions of "Show grants"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
* <code>[[SELECT User]] FROM mysql.user;</code> | * <code>[[SELECT User]] FROM mysql.user;</code> | ||
* [[CREATE DATABASE]] | * [[CREATE DATABASE]] | ||
| + | * [[CREATE USER]] | ||
== See also == | == See also == | ||
Latest revision as of 19:38, 28 July 2021
show grants; +------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED VIA unix_socket WITH GRANT OPTION | | GRANT PROXY ON @'%' TO 'root'@'localhost' WITH GRANT OPTION | +------------------------------------------------------------------------------------------------+ 2 rows in set (0.000 sec)
Related terms[edit]
SELECT User FROM mysql.user;- CREATE DATABASE
- CREATE USER
See also[edit]
- MariaDB:
mariadbcheck,mariabackup,mysqldump, MyRocks,show (MariaDB)MariaDB Changelog,50-server.cnf, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, MariaDB files:.frm,.ibd,/etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries,show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306
Advertising:
