MySQL CLI Commands for New DB & User

mysql_commands.sql

# Create the database
create database test_database;

# Create a user with a password
create user 'username'@localhost identified by 'password';

# Give the new user full privileges on the new database
grant all privileges on test_database.* to 'username'@localhost;

# Refresh everyone's privileges
flush privileges;

--

# Dump Database
mysqldump -uusername -p test_database > backup.sql

# Restore Database - be careful this command is 100% right
mysql -uusername -p test_database < backup.sql