Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Giving Privileges at the Database Level

By: FYIcenter.com

(Continued from previous topic...)

How To Grant User Privileges at the Database Level?

If you want to grant a user privilege at the database level, you can use the "GRANT privilegeName ON databaseName.* TO userName" command. The argument "databasename.*" in the command stands for all tables in the specified database. The following tutorial exercise shows you how to create a new database and grant access privilege to a user only for this new database:

>cd \mysql\bin
>mysql -u root -pretneciyf

mysql> CREATE DATABASE faq;
Query OK, 1 row affected (0.04 sec)

mysql> CREATE USER qa IDENTIFIED BY 'iyf';
Query OK, 0 rows affected (0.24 sec)

mysql> GRANT CREATE ON faq.* TO qa;
Query OK, 0 rows affected (0.00 sec)

mysql> QUIT;

>mysql -u qa -piyf

mysql> USE faq;
Database changed

mysql> USE fyi;
ERROR 1044 (42000): Access denied for user 'qa'@'%' 
 to database 'fyi'

(Continued on next topic...)

  1. What Is a User Account?
  2. What Are the Predefined User Accounts?
  3. How To Add a New User Account?
  4. How To Test a New User Account and Password?
  5. How To Change the Password for Your Own User Account?
  6. How To Change the Password of Another User Account?
  7. How To Delete a User Account?
  8. How To List All Existing User Accounts?
  9. How To Rename an Existing User Account Name?
  10. What Are User Privileges?
  11. How Many Scope Levels Can User Privileges Apply?
  12. How To Grant User Privileges at the Global Level?
  13. How To Grant User Privileges at the Database Level?
  14. How To View User Privileges?
  15. How To Revoke User Privileges?
  16. How To Give a User Read-Only Access to a Database?
  17. Where Are User Privileges Stored on the Server?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...