Useful mysql commands

mysql

# connect
mysql -u root -p

# List databases
show databases;

# create database
create database database-name;

# Create user
CREATE USER 'new-user'@'localhost' IDENTIFIED BY 'password';
# Create user can be connected from everywhere
CREATE USER 'new-user'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database-name. * TO 'new-user'@'localhost';
FLUSH PRIVILEGES;