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; drop database;
Yeah ... call me stupid ;-)