Skip to main content
  1. Posts/

Setup a New Database and User in MySQL

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