Monday, March 16, 2015

MySQL database and user creation reminder

MySQL database and user creation reminder 



CREATE DATABASE DATABASENAME;

GRANT ALL PRIVIEGES ON DATABASENAME.* TO "USER"@"HOST" IDENTIFIED BY "PASSWORD";

FLUSH PRIVILEGES;