Difference between revisions of "Show grants"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
== Related terms == | == Related terms == | ||
* <code>[[SELECT User]] FROM mysql.user;</code> | * <code>[[SELECT User]] FROM mysql.user;</code> | ||
| − | + | * [[CREATE DATABASE]] | |
== See also == | == See also == | ||
Revision as of 19:36, 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
SELECT User FROM mysql.user;- CREATE DATABASE
See also
- 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:
