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 3yr ago