mysql has failed, please contact the sysadmin (result was “mysql has failed”).

mysql has failed error

Now a most common problem we are facing with the mysql on newly installed server if we have mysql 5 we mostly receive following error message when starting mysql service from WHM

“mysql has failed, please contact the sysadmin (result was “mysql has failed”).”

As well as when ever we run mysql from shell its gives error message

“Access denied for user ‘root’@’localhost’ (using password: YES)”.

In that case we need to remove mysql from server and reinstall it by using following commands.

1)Login into server as root user

root@Gunjan [~]# which mysql
/usr/bin/mysql

root@Gunjan [~]#mv /usr/bin/mysql /usr/bin/mysql-back

root@Gunjan [~]mv /var/lib/mysql /var/lib/mysql-back

root@Gunjan [~]/scripts/mysqlup  –force

Now reset the root password from WHM >> Main >> SQL Services >> MySQL Root Password

Now you will able to access mysql without any problem 🙂

 

Some time above solution also not allowing to access mysql still throws following error message.

root@server[~]#mysql
“Access denied for user ‘root’@’localhost’

In that case refer following steps but carefully as it will cause you database loss.

root@server[~]#/etc/init.d/mysql stop

root@server[~]#mv /var/lib/mysql/ /var/lib/mysql-back

root@server[~]#mv /etc/my.cnf /etc/my.cnf-back

root@server[~]#/scripts/mysqlup –force

root@server[~]#/etc/init.d/mysql start

root@server[~]#mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1430564
Server version: 5.0.85-community MySQL Community Edition (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> \q
Bye

Now you can restore the databases from /var/lib/mysql-back to /var/lib/mysql

About Anant 373 Articles
Senior technical writer