HOWTO: Create a MySQL User & Database

sudo mysql -u root -p
CREATE DATABASE testjsdb;
CREATE USER testjsusr@ IDENTIFIED BY "PasswordToUse";
GRANT ALL PRIVILEGES ON testjsdb.
TO ‘testjsusr’@’%’ IDENTIFIED BY ‘PasswordToUse’;
FLUSH PRIVILEGES;

Powered by BetterDocs

Leave a Reply