Difference between revisions of "Database"

From Things and Stuff Wiki
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

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

https://github.com/tanin47/php_db_migrate


Other