cat $HOME/.my.cnf
[client]
password="rootpassword"
/usr/local/mysql/bin/mysql --defaults-file=$HOME/.my.cnf
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Oh. That changes things. The error says "Using password: YES". (You told me it said "Using password: NO" before). That would indicate that mysql did read your .my.cnf file, but doesn't believe it contains the correct password. Double-check you don't have a typo in there. Another possibility might be a special character such as a " or # in the password.
There's the problem. Your original advice was to include:
In the case of root cron jobs then, you need a .my.cnf readable only by root in root's home. It should include
[client] password="mysql_root_password"
This is incorrect, unless the double quotes are part of the password. Removing them so that the entry reads:
[client] password=mysql_root_password
will correct the problem.
___/ / __/ / ____/ Ed Leafe
Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]