|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: secure automated access (was "Re: Backing up all databases")
From: Randall Perry (rgp
systame.com)
Date: Thu Nov 13 2003 - 13:28:42 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 ]