create database DBNAME; CREATE USER 'USERNAME'@'localhost' IDENTIFIED BY 'P@ssw0rd'; GRANT ALL PRIVILEGES ON DBNAME.* TO 'USERNAME'@'localhost'; flush privileges;
create database DBNAME; CREATE USER 'USERNAME'@'localhost' IDENTIFIED BY 'P@ssw0rd'; GRANT ALL PRIVILEGES ON DBNAME.* TO 'USERNAME'@'localhost'; flush privileges;