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
• Remote Clients Cannot Connect - #mysql wiki

• • • 6.3.5. Assigning Account Passwords

• • 13.8.1. DESCRIBE Syntax
  • C.5.4.1. How to Reset the Root Password

Commands

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

http://dev.mysql.com/doc/refman/5.6/en/create-user.html

show databases;
show tables;

use [db name];

flush privileges;

grant all on userdatabase.* TO 'username'; [1]

13.7.5.17. SHOW GRANTS Syntax

http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html

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 ;

MariaDB

• MariaDB Knowledge Base
  • Using mysqlbinlog

Web interfaces

• phpMyAdmin
  • docs
  • wiki

• Chive

Admin

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

mysqldump

• mysqldump
  • http://stackoverflow.com/questions/104612/run-mysqldump-without-locking-tables
  • http://www.cyberciti.biz/faq/linux-unix-mysqldump-got-error1044-access-denied/

Tools

• dbdeploy is a Database Change Management tool.
  • 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

• dBug - "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/

• http://phppgadmin.sourceforge.net/doku.php

• http://datomic.com/

• http://highscalability.com/blog/2012/7/9/data-replication-in-nosql-databases.html