mysqlcheck: Error 1045 appears to ignore defaults file

[Charles Belov]

I had been running mysqlcheck successfully each night in cron, Now it has stopped running without my knowingly having changed anything.

Cron output:

Subject: Cron <{FreeBSD user name redacted}> /usr/local/bin/mysqlcheck --defaults-file=/root/.{FreeBSD user name redacted}_mysqlcheck.cnf {data base name redacted}

/usr/local/bin/mysqlcheck: Got error: 1045: Access denied for user
'{FreeBSD user name redacted}'@'localhost' (using password: NO) when trying to connect

Here are the permissions for the default file:

-rw------- 1 {FreeBSD user name redacted} {FreeBSD group name redacted} - 125 May 26 13:44 .{FreeBSD user name redacted}_mysqlcheck.cnf

Here's the content of .{FreeBSD user name redacted}_mysqlcheck.cnf:

[client]
user="{mySQL user name redacted}"
password="{mySQL user password redacted}"

[mysqlcheck]
analyze
auto-repair
force
host=localhost
optimize
verbose

Here's the strange part:

1. It is saying "(using password: NO)" in the error message even though the configuration file has a password specified.
2. It appears to be denying access to the FreeBSD user even though the configuration file specifies a different name for the mySQL user.
3. Another program, which uses its own proprietary format for its own configuration file, is continuing to run fine.

I have verified that the mySQL user name and the mySQL password are the same in both configuration files, and that both specify localhost. The respective cron jobs, which are run for the same FreeBSD user, specify the same database name.

FreeBSD 6
MySQL 5.0.24



Edited 1 time(s). Last edit at 05/27/2011 02:28PM by Charles Belov.