Category Archives: MySQL

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.* … Continue reading

Posted in MySQL | Leave a comment