Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Lentes, Bernd (bernd.lenteshelmholtz-muenchen.de)
Date: Sun May 16 2010 - 08:41:27 CDT
Carlos mennens wrote:
> Can you guys recommend something for me here? I don't really
> know enough about MySQL 'grant' permissions to determine
> which would work or if the 'backup' user would require high
> level privileges.
Set the rights of the script file to rwx------ . So only the owner can read it. Or provide in the home of the user who executes the script a file named .my.cnf . Inside that file you provide a section [mysqld] , where you can specify the user and the password to connect to the database. Also this file has only to be readable for the user who executes the script (rwx------).
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql