From: Randall Perry (rgpsystame.com)
Date: Thu Nov 13 2003 - 15:32:36 CST

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

on 11/13/03 3:57 PM, Michael Stassen at Michael.Stassenverizon.net wrote:

> The client (mysql) reads the .my.cnf file when you start it, so
> restarting mysqld and relogging in as root are not necessary.
>
> Let's see if I have this straight: While logged in as root, you created
> .my.cnf in root's home directory. This file contains the password for
> the mysql user "root". Yes? Did you make sure the file was readable
> only by root (`chmod 600 .my.cnf` would do the trick)?
>
Permissions are correct. Here's a cat of the file with password changed:

# cat /private/var/root/.my.cnf
[client]
password="rootpassword"

> Since I'm not sure exactly what happened, I don't know why this didn't
> work for you. When you say nothing works, do you mean you cannot
> connect via mysql interactively, or your cron job doesn't work? What
> error did you get?
>
> If you haven't already, try running mysql. Do you get in, or do you get
> "ERROR 1045: Access denied for user: 'rootlocalhost' (Using password:
> NO)", or do you get something else?
>
Yes, that's the error.

> If you don't get in, try
>
> mysql --defaults-file=/path/to/.my.cnf
>
That also doesn't work.

> If that works, then .my.cnf isn't in the right place.
>
> If mysql works interactively, but not via cron, then the problem to be
> fixed lies with cron. What error do you get from cron?
>
Doesn't work at all.

> Michael
>
> Randall Perry wrote:
>> I created the .my.cnf file in root's home dir, added the directives below
>> setting the correct password. Restarted mysqld, re-logged in as root, but
>> nothing works. It's not getting the password.
>>
>>
>>
>>> The simplest solution is to keep the password in the .my.cnf file in
>>> your home directory. See http://www.mysql.com/doc/en/Option_files.html
>>> in the manual.
>>>
>>> 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"
>>>
>>> As mysql reads the .my.cnf file, this avoids the ps "sniffing" problem,
>>> and also keeps the password out of the script. Because you make the
>>> .my.cnf file readable only by root, other users can't see it. (If they
>>> can see it, you've got bigger problems than just the mysql password).
>>>
>>> Michael
>>
>>
>>

--
Randall Perry
sysTame

Xserve Web Hosting/Co-location
Website Development/Promotion
Mac Consulting/Sales

http://www.systame.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

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