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? >> YesORservice mysql restartOR/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 stop2. Start the MySQL without password - mysqld_safe --skip-grant-tables &3. Connect to MySQL server as the root user - mysql -u root4. 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> quit5. Stop and restart the MySQL service.
Let me know if you've any thoughts.
Was this answer helpful?
To prevent xmlrpc attack in WordPress website just add below code to the .htaccess file of the...
I tried accessing the email account from one of the email client on my desktop. It was generating...
While accessing the site I was getting error as -'Failed to open dir: Permission denied in...
While accessing Opencart site, I was getting error as 'Fatal error: Call to undefined function...
phpMyAdmin and MySQL Databases in cPanel were displaying me the below error -...
Powered by WHMCompleteSolution