Allowing wildcard (%) access on MySQL db, getting error "access denied for '<user>'@'localhost'"
- by Wayne M
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?