====== MySQL ====== ==== CLI usage ==== ^Command ^ Description ^ |''mysql -u root -p''|Authenticate and connect (interactive mode)| |''mysqldump --databases //{DATABASE}// > output.sql'' \\ ''mysqldump -u root --password=//{PASSWORD}// //{DATABASE}// -c > output.sql''| Dump //DATABASE//| ==== SQL expressions ==== ^ Command ^ Description ^ |''SHOW DATABASES;''|Show all databases| |''SHOW TABLES in //{DATABASE}//;''|Show all tables in //DATABASE//| |''DROP DATABASE //{DATABASE}//;''|Delete //DATABASE//|