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

• http://www.pantz.org/software/mysql/mysqlcommands.html

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

SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

Web interfaces

• phpMyAdmin
  • docs
  • wiki

• Chive

Admin

• http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLServerDatabases.aspx

Tools

• http://dbdeploy.com/
• http://davedevelopment.co.uk/2008/04/14/how-to-simple-database-migrations-with-phing-and-dbdeploy.html

https://github.com/tanin47/php_db_migrate

• https://bitbucket.org/stepancheg/mysql-diff/wiki/Home

• http://dbug.ospinto.com/ - "PHP version of ColdFusion’s cfdump. Outputs colored and structured tabular variable information. Variable types supported are: Arrays, Classes/Objects, Database and XML Resources."

Other

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

• http://developers.memsql.com/