Create MySQL User

Login as root user, and enter:

mysql -uroot -p

then enter MySQL root password and enter

CREATE DATABASE example_one;

Finally, run the following command:

GRANT ALL PRIVILEGES ON example_one.* TO 'exampleuser'@'localhost' IDENTIFIED BY 'SomERand0mPas$WorD' WITH GRANT OPTION;

Author: Christopher Smith

I managed websites.

Leave a Reply

Your email address will not be published. Required fields are marked *