Difference between revisions of "Show grants"
Jump to navigation
Jump to search
(Created page with " show grants; +------------------------------------------------------------------------------------------------+ | Grants for root@localhost...") |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | show grants; | + | [[Show (MariaDB)|show]] grants; |
+------------------------------------------------------------------------------------------------+ | +------------------------------------------------------------------------------------------------+ | ||
| Grants for root@localhost | | | Grants for root@localhost | | ||
| Line 10: | Line 10: | ||
2 rows in set (0.000 sec) | 2 rows in set (0.000 sec) | ||
| + | == Related terms == | ||
| + | * <code>[[SELECT User]] FROM mysql.user;</code> | ||
| + | * [[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, /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:
