Difference between revisions of "Database"
Jump to navigation
Jump to search
Line 41: | Line 41: | ||
* http://www.chive-project.com/ Chive] | * http://www.chive-project.com/ 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 | ||
+ | |||
+ | |||
== Other == | == Other == | ||
* http://radar.oreilly.com/2012/02/nosql-non-relational-database.html - http://news.ycombinator.com/item?id=3610844 | * http://radar.oreilly.com/2012/02/nosql-non-relational-database.html - http://news.ycombinator.com/item?id=3610844 |
Revision as of 18:19, 22 June 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
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';
Web interfaces
Admin
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