Difference between revisions of "Database"

Revision as of 03:23, 15 June 2012

show databases;
use [db name];
show tables;
flush privileges;
GRANT ALL ON USERDATABASE.* TO 'USERNAME'; [1]

Create command list for showing user grants [2]

SELECT CONCAT("SHOW GRANTS FOR '",user,"'@'",host,"';") FROM mysql.user WHERE host!='localhost';

@@ Line 25: / Line 25: @@
 === Commands ===
- FLUSH PRIVILEGES;
-[http://www.softwareprojects.com/resources/programming/t-how-to-restrict-mysql-user-access-to-a-single-datab-1734.html]
+* http://www.pantz.org/software/mysql/mysqlcommands.html
- GRANT ALL ON USERDATABASE.* TO 'USERNAME';
+ show databases;
+ use [db name];
+ show tables;
+ flush privileges;
+ GRANT ALL ON USERDATABASE.* TO 'USERNAME'; [http://www.softwareprojects.com/resources/programming/t-how-to-restrict-mysql-user-access-to-a-single-datab-1734.html]
 Create command list for showing user grants [http://www.pythian.com/news/1165/creative-sql-how-to-easily-show-grants-for-many-users/]