Add user for phpMyAdmin in command line

Background :

Wamp + phpMyAdmin

Objective :

By default, there is no user for phpMyAdmin, so we will create one.

Method :

1. Open the terminal of mysql in Wamp.

2. Type Enter.

3. Commands :

# create a user

CREATE USER 'yourUsername'@'localhost' IDENTIFIED BY 'yourPassword';

# grant all the privilege to the user

GRANT ALL PRIVILEGES ON *.* TO 'yourUsername'@'localhost'
IDENTIFIED BY 'yourPassword' WITH GRANT OPTION;