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]

Reply via email to