Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Grant User Privileges at the Global Level
How To Grant User Privileges at the Global Level? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: 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)
2007-05-10, 4523👍, 0💬
Popular Posts:
How To View All Columns in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If ...
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental obj...
What are the different accessibility levels defined in .NET ? Following are the five levels of acces...
What is the purpose of finalization? The purpose of finalization is to give an unreachable object th...
Does there exist any other function which can be used to convert an integer or a float to a string? ...