I've created a database and a user, and allowed access via the following:
create user 'someuser'@'%' identified by 'password'; grant all privileges on somedb.* to 'someuser' with grant option;
however, when I try to connect to MySQL I get the following error:
$ mysql -u someuser -p > Enter Password: > ERROR 1045 (28000): Access denied for user 'someuser'@'localhost' (using password: YES)
If "%" is the wildcard, then wouldn't it also enable localhost? However, if I do not specify that I want to use a password, then I can connect just fine to the database, which makes no sense because I'm specifying a password when I created the user.