SQL Cheat Sheet

At the first login, you will be asked to set up a SQL root account.

Make sure to remember the password later!

Shell

sudo mysql -u root -p

Create database.

Shell

create database cloud;

Show database.

Shell

SHOW DATABASES;

Create user 'UserName' with a password.

Password needs to be written between the apostrophes!

Shell

CREATE USER UserName@localhost IDENTIFIED BY 'password';

Grant database to user.

Shell

GRANT ALL ON cloud.* TO UserName@localhost IDENTIFIED BY 'password';

Save.

Shell

flush privileges;

Exit SQL.

Shell

exit;