Create user and grant basic rights in MySQL
Just a quick one.
Sometimes you would like to try out new software and need to create a frest environment for it. Just add a new database, user and some rights to MySQL and you have all you need:
– The Database:
CREATE DATABASE newsoftware;
– User:
CREATE USER ‘user1′@’localhost’ IDENTIFIED BY ‘pass1′;
– Too much right for the user:
GRANT ALL ON newsoftware.* TO ‘user1′@’localhost’;
That’s it, now you can try the software. If it is crap not good, just remove user and drop database.. 
Tags: create database, create mysql database, create user, MySQL