mysql & eximstats failed

[claven177]

I can not restart mysql and eximstats failed.
If I click http://mydonai:2086/3rdparty/phpMyAdmin/index.php (phpmyadmin on WHM)
Always show
Wrong username/password. Access denied.
It is strange, althought mysql has failed, I can read phpbb2 forum ( Mysql is normal)
Why I can not restart mysql ?


================================================== ==

mysql failed @ Sat Apr 8 06:27:51 2006. A restart was attempted automagicly.

eximstats failed @ Sat Apr 8 06:27:51 2006. A restart was attempted automagicly


================================================== ==

Attempting to restart mysql
Waiting for mysql to restart.... . . . . . . . . . . finished.

mysql statusroot 12685 0.3 0.1 2052 1060 ? S 06:19 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/p4.mydomain.com.pid
mysql 12714 0.2 0.2 190900 2368 ? S 06:19 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/p4.mydomain.com.pid --skip-locking --socket=/var/lib/mysql/mysql.sock

================================================== ==
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[email protected]' (Using password: YES)' mysql has failed, please contact the sysadmin (result was "mysql has failed").

 

[jeffheld]

Mysql Fixed

I am having the same problems. So far I only got Mysql running.

My problem was the default mysql database didn't have any of the required tables.

So I rebuild them with this command from mysql.com

/usr/bin/mysql_install_db --user=mysql

That re-creates the default tables...that fixed it.

You may need to change your path to that script.

 

[maximus_marcus]

Hello,

This is probably because your mysql got upgraded on the server and it causing some compatiblities issue. Try adding the line old-passwords to the my.cnf and then restarting .

Let me know if you need any further assistance with this .