MySql

# Connection syntax
mysql -u <user> -p
# Show databases
show databases;
# Use database
use <databasename>;
# Show tables
show tables;
# Disconnect
exit;

# New drivers syntax
CREATE USER 'newuser'@'localhost' IDENTIFIED BY '<password>';
# Old drivers syntax
CREATE USER 'newuser'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';

# Grant all privileges
GRANT ALL PRIVILEGES ON * . * TO '<user>';

source <file_path>