At 12:37 +0300 12/24/02, [EMAIL PROTECTED] wrote:
>Description:
The command
GRANT ALL ON dbname.* TO larry@"%" IDENTIFIED BY 'larry123';
FLUSH PRIVILEGES;
properly changes the mysql.user table. However, if I subsequently
attempt to use the mysql client like this
mysql -h <myhostname> -u larry -p dbname
and enter 'larry123' at the password prompt, I get an error:
Access denied for user: 'larry@myhostname' (Using password: YES)
When you try this, are you running the mysql command on the server host?
If so, you're running into problems that are due to the anonymous-user
entries in the mysql.user table. Remove them, issue a FLUSH PRIVILEGES
statement, and try again. The problem will go away.
But this is wrong, it seems. If I look in the mysql.user table,
I find this line:
% | larry | <encrypted password> | ...
suggesting that the correct information is there, but that
the wildcard '%' is not working.
---------------------------------------------------------------------
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
