Difference between revisions of "Database"
Jump to navigation
Jump to search
(a move) |
|||
| Line 25: | Line 25: | ||
=== Commands === | === Commands === | ||
| + | [http://www.softwareprojects.com/resources/programming/t-how-to-restrict-mysql-user-access-to-a-single-datab-1734.html] | ||
| + | GRANT ALL ON USERDATABASE.* TO 'USERNAME'; | ||
| + | |||
Create command list for showing user grants [http://www.pythian.com/news/1165/creative-sql-how-to-easily-show-grants-for-many-users/] | Create command list for showing user grants [http://www.pythian.com/news/1165/creative-sql-how-to-easily-show-grants-for-many-users/] | ||
SELECT CONCAT("SHOW GRANTS FOR '",user,"'@'",host,"';") FROM mysql.user WHERE host!='localhost'; | SELECT CONCAT("SHOW GRANTS FOR '",user,"'@'",host,"';") FROM mysql.user WHERE host!='localhost'; | ||
Revision as of 00:38, 23 May 2012
MySQL
- MySQL Reference Manuals
- 4.3.1. mysqld — The MySQL Server
- 4.6.7. mysqlbinlog — Utility for Processing Binary Log Files
- 5.1.2. Server Command Options
- 5.3. MySQL Server Logs
- 6.2. The MySQL Access Privilege System
- 13.7.5.17. SHOW GRANTS Syntax
- 13.7.1.3. GRANT Syntax
- 13.7.6.2. FLUSH Syntax
- 13.8.1. DESCRIBE Syntax
- C.5.4.1. How to Reset the Root Password
Commands
GRANT ALL ON USERDATABASE.* TO 'USERNAME';
Create command list for showing user grants [2]
SELECT CONCAT("SHOW GRANTS FOR '",user,"'@'",host,"';") FROM mysql.user WHERE host!='localhost';