This follows on a previous mail from me:

When using 
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
“password”

I could not get the password authentication to kick
in. Only supplying no password (empty string)
succeeded. Even after doing “SET PASSWORD…” and “FLUSH
PRIVILEGES”.

Then I tried 
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
“password”

And now it works – the new password must be supplied
for the user to logon.
Does the “%” domain not include the localhost domain?
If not, what is the use of the “%” domain? When should
I use “%” and when “localhost” ?


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to