Create new Database and User

Open Database Console

sudo mysql -uroot -p

Create User

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

Create Database

CREATE DATABASE <database-name>;

Authorise User for Database

GRANT ALL ON <database-name>.* TO '<username>'@'localhost';

Activate Changes

FLUSH PRIVILEGES;

Exit Database Console

exit