Skip to main content

Setup a New Database and User in MySQL

sudo mysql
create database my_database;
CREATE USER 'user'@'localhost' IDENTIFIED BY 'PASSWORD';
GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost';
flush privileges;