Collections:
Giving Privileges at the Database Level in MySQL
How To Grant User Privileges at the Database Level in MySQL?
✍: FYIcenter.com
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'
⇒ Viewing User Privileges in MySQL
⇐ Giving Privileges at Server Level in MySQL
2017-08-21, 1421🔥, 0💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...