Do this as root in mysql

• create user 'user1'@'localhost' identified by 'pass1';
• grant select,insert,update,delete on .* to 'user1'@'localhost';
• flush privileges;

the following grants all

• grant all on database.* to 'user1'@'localhost';
• flush privileges;

Obviously user1 and pass1 are the actual user and password!

Remove a user

• drop user 'user1';
• flush privileges;

then remove the associated databases from the db column in mysql using phpmyadmin