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, 1521🔥, 0💬
Popular Posts:
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...