Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Where Are User Privileges Stored on the Server
Where Are User Privileges Stored on the Server? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: 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)
2007-05-08, 5257👍, 0💬
Popular Posts:
Why is it preferred to not use finalize for clean up? Problem with finalize is that garbage collecti...
How To Select All Columns of All Rows from a Table? - MySQL FAQs - SQL SELECT Query Statements with ...
What invokes a thread's run() method? After a thread is started, via its start() method of the Threa...
What is the FP per day in your current company?
What will the following piece of code do? int f(unsigned int x) { int i; for (i=0; x!=0; x>&a...