Baron Schwartz a écrit :
> Miguel Cardenas wrote:
>> Hello list
>> I have a problem adding a user with host '%' ...
>> *** If I add a user with host '%' when trying to connect get this error:
>> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
>> password: YES)
>> *** If I add the same user with localhost it connects and works fine...
>> My specific doubt is:
>> 1) do I need to add a same user with both '%' and 'localhost' to
>> connect locally and from another location???, or...
>> 2) for some reason a host '%' is not working or need to do something
>> so it allows connections from any host?
> Remember to quote the user and host carefully. So,
> GRANT ... TO 'user'@'%'
> GRANT ... TO user@%
> If you have doubts about what you actually granted, do this:
> SHOW GRANTS FOR 'user'
> And see what host it claims the permissions are for. If you did it
> wrong, it will say no such user exists. If you do all this and
> everything looks okay, write back to the list again and maybe we can
> help you more.
> Oh, one more place to look is at the server configuration in /etc/my.cnf
> or equivalent, to be sure networking is configured right. You want to
> check the bind-address and skip-networking settings. You don't want
> skip-networking, and you want bind-address set to the machine's IP
> address. Now that I think of it, this is more likely to be the problem
> for you.
Localhost is indeed a special value that isn't include in '%'. It's a
feature not a bug ;)
GPG keys available @ http://rounoff.darktech.org