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]