Mysql create new database and user

Posted on December 10, 2015, 10:32 am, by admin, under mysql.
CREATE DATABASE testdatabase;
 
CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpassword';
 
GRANT ALL PRIVILEGES ON testdatabase.* TO 'testuser'@'localhost';
Comment (RSS)  |  Trackback

Leave a Reply

«
»