Using MySQL

Start MySQL Service

Windows

Start the MySQL service (from Task Manager)

Linux

sudo service mysql start

MacOS

Go to Settings > Mysql > Start MySQL Service

or (if installed via Homebrew)

mysqld.service start

Log in to MySQL as root

Without root password -

mysql -u root
mysql>

With root password -

mysql -u root -p
Enter Password:

mysql>

Create DB, User, Grant access

CREATE DATABASE mytestdb;

CREATE USER myuser IDENTIFIED BY 'mypass';

USE mytestdb;

GRANT ALL PRIVILEGES ON mytestdb.* TO myuser;

FLUSH PRIVILEGES;

Login using the new user

mysql -u myuser -p
Enter Password: (enter 'mypass' here)

mysql>