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, 1923🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...