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, /var/log/mysql/mariadb-slow.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,/etc/mysql/
Advertising: