Anil wrote:
Michael,
Just I want to know if we grant privileges with '%' wild card character will
it accept connection from 127.0.0.1. when I tried it is showing connection
request is coming from [EMAIL PROTECTED] and connection is not establishing . to
my knowledge '%' means it should accept connection from any host . please
clarify
Thanks
Anil
DBA
Anil,
To get meaningful help, you must provide meaningful information.
Descriptions of your understanding of an error message are a poor substitute
for the actual error message itself. If you want a definitive answer, you
need to supply the exact text of the error message you received (as I asked
in my previous message).
That said, I'll go out on a limb and take a guess. '%' does mean any host,
but '%' is the least specific of any possible host sppecification. You need
to read the description of the authentication process in the manual
<http://dev.mysql.com/doc/mysql/en/connection-access.html>. Entries in the
user table are sorted from most specific to least, with host taking
precedence over user. You are attempting to connect as [EMAIL PROTECTED], but
127.0.0.1 is localhost. Here are some possible users which would match, in
descending order of specificity:
[EMAIL PROTECTED]
''@localhost
[EMAIL PROTECTED]
[EMAIL PROTECTED]
My guess is you have a more specific entry than [EMAIL PROTECTED] that is a match. We
would know for sure if you included the error message.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
