Marc MENDEZ wrote:
Hi,
I work under Mandrake 10.1
First, I have a .my.cnf, which works quite well, since I can enter mysql
without entering any password.
Even mysqladmin works !
But, I have a batch process run by crontab as root, which tests if mysql
is running (mysqladmin version --silent).
Unfortunately, this command failed
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
So, I did a simple test : I just run "mysqladmin version" using the
"batch" command" (it runs a tasks as cron, but immediately) : it works !
The cron version doesn't know where the my.cnf file is, add:
--defaults-extra-file=/path/to/.my.cnf
to the end of your crontab line.
So:
mysql -u root --defaults-extra-file=/root/.my.cnf .....
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]