Collections:
Giving Privileges at Server Level in MySQL
How To Grant User Privileges at the Global Level in MySQL?
✍: FYIcenter.com
If you want to grant a user privilege at the global level, you can use the "GRANT privilegeName ON *.* TO userName" command. The argument "*.*" in the command stands for all database and all tables. The following tutorial exercise shows you how to create a new database and grant access privilege to a user on this new database:
>cd \mysql\bin >mysql -u root -pretneciyf mysql> CREATE DATABASE fyi; Query OK, 1 row affected (0.01 sec) mysql> QUIT; >mysql -u dev -piyf mysql> USE fyi; ERROR 1044 (42000): Access denied for user 'dev'@'%' to database 'fyi' mysql> QUIT; >mysql -u root -pretneciyf mysql> GRANT CREATE ON *.* TO dev; Query OK, 0 rows affected (0.00 sec) mysql> QUIT; >mysql -u dev -piyf mysql> USE fyi; Database changed mysql> CREATE TABLE TEST (id INTEGER); Query OK, 0 rows affected (0.09 sec)
⇒ Giving Privileges at the Database Level in MySQL
⇐ Scope Levels of User Privileges in MySQL
2017-08-21, 1510🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...