CREATE DATABASE `database_name` CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT ALL ON `database_name`.* TO `username`@localhost IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
Alternate option by using 'CREATE SCHEMA'
CREATE SCHEMA `database_name` CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT ALL ON `database_name`.* TO `username`@localhost IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
No comments:
Post a Comment