MySQL

Login:mysql -u USERNAME -pPASSWORD
Dump:mysqldump -u USERNAME -pPASSWORD DATABASENAME > DUMP.SQL
Restore:mysql -u USERNAME -pPASSWORD DATABASENAME < DUMP.SQL
Add user:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
List databases:SHOW DATABASES;
Add database:CREATE DATABASE databasename;
Use database:USE databasename;
Drop database:DROP DATABASE databasename;
Last modified 2yr ago