The MySQL server is currently offline. Mysql::initcache() failed: The mysql server is offline.

I was getting below error while accessing MySQL Databases from cPanel though MySQL service was running on server -
The MySQL server is currently offline.
Mysql::initcache() failed: The mysql server is offline.

Solution :-

1. Restart MySQL on server -

WHM >>Restart Services >> SQL Server (MySQL) >> Are you sure you wish to restart this service? >> Yes
OR
service mysql restart
OR
/etc/init.d/mysqld start

2. Reset MySQL root password - ( It's stored in '/root/.my.cnf', which cPanel updates when you change the password.)

1. Stop the MySQL running on server - service mysql stop
2. Start the MySQL without password - mysqld_safe --skip-grant-tables &
3. Connect to MySQL server as the root user - mysql -u root
4. Now reset new password for MySQL's root user -
mysql> use mysql;
mysql> update user set password=PASSWORD("New_Root_-Password") where User='root';
mysql> flush privileges;
mysql> quit
5. Stop and restart the MySQL service.

Let me know if you've any thoughts.

Was this answer helpful?

 Print this Article

Also Read

How to prevent xmlrpc attack on the WordPress?

To prevent xmlrpc attack in WordPress website just add below code to the .htaccess file of the...

Authentication Failed - Email password is not working in desktop application

I tried accessing the email account from one of the email client on my desktop. It was generating...

Failed to open dir: Permission denied in /usr/local/lib/php/autoindex/default.php

While accessing the site I was getting error as -'Failed to open dir: Permission denied in...

Fatal error: Call to undefined function utf8_substr()

While accessing Opencart site, I was getting error as 'Fatal error: Call to undefined function...

MySQL server is currently offline. Error: Too many connections at /usr/local/cpanel/Cpanel/Mysql.pm line 173.

phpMyAdmin and MySQL Databases in cPanel were displaying me the below error -...

Powered by WHMCompleteSolution