Database

From Things and Stuff Wiki
Revision as of 18:21, 22 June 2012 by Milk (talk | contribs) (→‎Tools)
Jump to navigation Jump to search


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

  • 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