SQL notes

Connect to SQL server

$ mysql -u <username> -p

Create user

CREATE USER <username>@localhost
IDENTIFIED BY '<password>';

Change password

CREATE USER <username>@localhost
IDENTIFIED BY '<password>'; -- new password

List all databases

SHOW DATABASES;

Create new database

CREATE DATABASE <name>;