Create a New MySQL Database and User

local:~ mysql -u root -p
create database new_db;
use new_db;
create user 'new_user'@'localhost' identified by 'password';
grant all privileges on new_db.* to 'new_user'@'localhost';
flush privileges;

Leave a Reply

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