Hi.
That's the documented behaviour:
http://www.mysql.com/doc/C/o/Connection_access.html
For "jwgas@localhost" the entry "@localhost" has a higher precedence
than "jwgas@%" because it is considered more specific. You may want
consider removing the "@localhost" entry completely, depending on your
needs.
Bye,
Benjamin.
On Thu, May 30, 2002 at 01:42:29PM -0700, [EMAIL PROTECTED] wrote:
[...]
> [root@linux01 rcv]# mysql -u jwgas -p
> Enter password:
> ERROR 1045: Access denied for user: 'jwgas@localhost'
> (Using password: YES)
>
> But if I specify an ip address, I can !?
[...]
> mysql> select user, host from user;
> +-------------+----------------+
> | user | host |
> +-------------+----------------+
[...]
> | jwgas | % |
> | | localhost |
> +-------------+----------------+
>
> user jwgas should be allowed from any host!? is there
> any restriction on localhost?
>
> Thanks,
> John
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
