My SQL {Tools}

From personal use

• SHOW DATABASES; SHOW TABLES; ...
• mysql -u username < script.sql
• GRANT ALL PRILIVEGES on sphinx.* TO sphinxsearch@localhost;
• CREATE database 'sphinx';
• CREATE USER 'sphinxsearch'@'localhost' IDENTIFIED BY 'some_pass';
• innodb disabled makes a much lower memory footprint
• help : the MOST important command ;)

Official documentation

• http://dev.mysql.com/doc/

To explore

• replace linkchecker sqlite usage to MySQL

See also

• SQLite

Note

My notes on Tools gather what I know or want to know. Consequently they are not and will never be complete references. For this, official manuals and online communities provide much better answers.