I am using mysql 4.1 on a windows environment, and have so far been unable
to create a user to use with a particular database, other than the root user
I have tried:
use database;
GRANT SELECT, INSERT, UPDATE, DELETE TO 'username'@'localhost' IDENTIFIED
BY 'password';