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, 1903🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...