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, 2153🔥, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...