From: Ed Leafe (edleafe.com)
Date: Mon Nov 17 2003 - 05:59:53 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Monday, November 17, 2003, at 02:58 AM, Michael Stassen wrote:

>> cat $HOME/.my.cnf
>> [client]
>> password="rootpassword"
>> /usr/local/mysql/bin/mysql --defaults-file=$HOME/.my.cnf
>> ERROR 1045: Access denied for user: 'rootlocalhost' (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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]