mysqladmin: connect to server at 'localhost' failed

chips12

Active Member
Nov 6, 2010
25
0
51
UK
For the last couple of days I have been receiving an email whenever the optimisefs cron runs.

saying:
Code:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
This is the cron that runs, a system process I think,

Code:
/usr/bin/test -x /usr/local/cpanel/bin/optimizefs && /usr/local/cpanel/bin/optimizefs
I have tried resetting the sql root password, but when i start mysql then check
mysqladmin proc

I get the same error that the connection failed using the password.

I am not sure what to do or why this has suddenly started happening.
 

chips12

Active Member
Nov 6, 2010
25
0
51
UK
I thought I would post how I fixed this, just in case anyone googles the same error and finds the question...

I had changed the mysql root password and being security conscious had used a mixture of alpha numeric AND special characters.

It was the special characters in the password that were causing the problem. I changed the password to be just alpha numeric and [email protected] was able to connect to mysql once again.