Difference between revisions of "Database"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
*** [http://dev.mysql.com/doc/refman/5.1/en/access-denied.html 6.2.7. Causes of Access-Denied Errors] | *** [http://dev.mysql.com/doc/refman/5.1/en/access-denied.html 6.2.7. Causes of Access-Denied Errors] | ||
*** [http://dev.mysql.com/doc/refman/5.0/en/assigning-passwords.html 6.3.5. Assigning Account Passwords] | *** [http://dev.mysql.com/doc/refman/5.0/en/assigning-passwords.html 6.3.5. Assigning Account Passwords] | ||
| + | ** [http://dev.mysql.com/doc/refman/5.5/en/grant.html 13.7.1.3. GRANT Syntax] | ||
** [http://dev.mysql.com/doc/refman/5.0/en/show-grants.html 13.7.5.17. SHOW GRANTS Syntax] | ** [http://dev.mysql.com/doc/refman/5.0/en/show-grants.html 13.7.5.17. SHOW GRANTS Syntax] | ||
| − | |||
** [http://dev.mysql.com/doc/refman/5.0/en/flush.html 13.7.6.2. FLUSH Syntax] | ** [http://dev.mysql.com/doc/refman/5.0/en/flush.html 13.7.6.2. FLUSH Syntax] | ||
** [http://dev.mysql.com/doc/refman/5.0/en/describe.html 13.8.1. DESCRIBE Syntax] | ** [http://dev.mysql.com/doc/refman/5.0/en/describe.html 13.8.1. DESCRIBE Syntax] | ||
Revision as of 00:41, 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.1.3. GRANT Syntax
- 13.7.5.17. SHOW GRANTS 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';