Collections:
User Privilege Tables in MySQL
Where Are User Privileges Stored on the Server in MySQL?
✍: FYIcenter.com
MySQL server has a system database, which hosts a number of system tables to system related information like user privileges. Depending on the scope levels, granted user privileges are stored in different tables:
The following tutorial exercise shows you an example of granted privileges at the table level:
>cd \mysql\bin >mysql -u root -pretneciyf mysql> SELECT db, user, create_priv, select_priv -> FROM mysql.db; +---------+-------+-------------+-------------+ | db | user | create_priv | select_priv | +---------+-------+-------------+-------------+ | test | | Y | Y | | test\_% | | Y | Y | | fyi | guest | N | Y | | faq | qa | Y | N | +---------+-------+-------------+-------------+ 4 rows in set (0.00 sec)
⇒ Server Daemon mysqld Administration in MySQL
⇐ Giving User Read-only Access in MySQL
2017-12-09, 1940🔥, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...