Database

From Things and Stuff Wiki
Revision as of 10:04, 20 July 2012 by Milk (talk | contribs) (→‎Other)
Jump to navigation Jump to search


MySQL

Commands

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 ;


SQLite

MariaDB

Web interfaces

Admin

mysqldump

Tools

  • 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