New MySQL database

Here is the syntax for creating a new db in MySQL with a login and full permissions for that user. Perfect for setting up that L.A.M.P. :-)

CREATE DATABASE verity_db;

CREATE USER 'verity_user'@'localhost' IDENTIFIED BY 'password';

GRANT ALL ON verity_db.* TO 'verity_user'@'localhost';

FLUSH PRIVILEGES;
This entry was posted in MySQL. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *