Giving Privileges at Server Level in MySQL

Q

How To Grant User Privileges at the Global Level in MySQL?

✍: FYIcenter.com

A

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)

 

Managing User Accounts and Access Privileges in MySQL

⇒⇒MySQL Database Tutorials

2017-08-21, 358👍, 0💬