Database

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
    • 5.3.1. The Error Log
  • 6.2. The MySQL Access Privilege System
    • 6.2.6. When Privilege Changes Take Effect
    • 6.2.7. Causes of Access-Denied Errors
    • 6.3.5. Assigning Account Passwords
  • 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

• MariaDB Knowledge Base

• http://kb.askmonty.org/en/using-mysqlbinlog

• http://hashmysql.org/wiki/Remote_Clients_Cannot_Connect

Commands

FLUSH PRIVILEGES;

[1]

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';

Web interfaces

• phpMyAdmin

• http://www.chive-project.com/ Chive]

Other

• http://radar.oreilly.com/2012/02/nosql-non-relational-database.html - http://news.ycombinator.com/item?id=3610844