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, 1391🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...