Hi i've installed Appserv which is a compilation of MySQL, Perl, PHP and Apache and i've gone into dos and loaded up MySQL with the root user and done:

grant all privileges
on *.*
to username@"%"
identified by "password"
with grant option

And that created the user, but now when i try to login as that user i get Access Denied, im thinking its because my username gets encrypted when stored in the mysql table...


Any ideas on how to get it working?