Casey

Full-Stack Developer

#sql

Create a MySQL User with a DB

CREATE DATABASE 'newdb';
CREATE USER 'newuser'@'%' IDENTIFIED BY 'newpassword';
GRANT ALL PRIVILEGES ON newdb.* TO 'newuser'@'%';
FLUSH PRIVILEGES;