on 11/13/03 3:57 PM, Michael Stassen at [EMAIL PROTECTED] 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: '[EMAIL PROTECTED]' (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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]