I still forget how to do the database and user creation and drop goes. So why not make a note.
create database test;
create user 'test' identified by 'pwtest';
grant all on test.* to 'test'@'localhost' identified by 'pwtest';
drop user test;
Yeah ... call me stupid ;-)