SQL

After install

ensure secure access sudo mysql_secure_installation

 

 Logging in 

mysql -u USERNAME -p

 

Creating a user

CREATE USER 'NEW_USERNAME'@'localhost' IDENTIFIED BY 'NEW_PASSWORD';

 

Creating a database

CREATE DATABASE DATABASE_NAME

 

Allow user to modify Database