The MySQL server is currently offline
Hello,
I am facing a problem with my virtual server. After c-panel updated I have a database connection error.
"The MySQL server is currently offline.
Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 165."
I talked with support but I didn't get any solution
Below is a part of the discussion from support:
-root@ip-166-62-46-102 [~]# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/ip-166-62-46-102.secureserver.net.pid).
-root@ip-166-62-46-102 [~]# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/ip-166-62-46-102.secureserver.net.pid).
-Looks to be a pretty severe issue with a database on the server.
and the PID document if you VIM to it is blank so that doesnt look right at all
Does anyone know how to solve this problem? and explain step by step what I have to do?
I am new in these things so I don't know a lot.
Thank you
-
Hello, Can you please check your mysql error logs file and let us know what error are you getting in that file. You can check this with the following command. /var/lib/mysql/ip-166-62-46-102.secureserver.net.pid0 -
It should be tail /var/lib/mysql/`hostname`.err0 -
Hello, I am facing a problem with my virtual server. After c-panel updated I have a database connection error. "The MySQL server is currently offline. Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 165." I talked with support but I didn't get any solution Below is a part of the discussion from support: -root@ip-166-62-46-102 [~]# service mysql start Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/ip-166-62-46-102.secureserver.net.pid). -root@ip-166-62-46-102 [~]# service mysql start Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/ip-166-62-46-102.secureserver.net.pid). -Looks to be a pretty severe issue with a database on the server. and the PID document if you VIM to it is blank so that doesnt look right at all Does anyone know how to solve this problem? and explain step by step what I have to do? I am new in these things so I don't know a lot. Thank you
You said that you talked with support and didn't get a solution, what is the ticket number? I assume you didn't get a solution since it was likely related to InnoDB corruption?0 -
Hello and thank you for replies. I get this when I am checking: -bash: /var/lib/mysql/ip-166-62-46-102.secureserver.net.pid: No such file or directory Also I talked with my server provider support not with c-panel support and I don't know the ticket number. 0 -
Hello, You will need to check /var/lib/mysql/ip-166-62-46-102.secureserver.net.err not /var/lib/mysql/ip-166-62-46-102.secureserver.net.pid 0 -
Hello, I get this: -bash: /var/lib/mysql/ip-166-62-46-102.secureserver.net.err: Permission denied Thank you 0 -
Hello, Yes, I apologies for my last update. Correct mysql error logs file name is /var/lib/mysql/ip-166-62-46-102.secureserver.net.err and you can check live mysql logs with the following command. tail -f /var/lib/mysql/ip-166-62-46-102.secureserver.net.err0 -
I'm happy to see the issue is now resolved. Thank you for updating us with the outcome. 0
Please sign in to leave a comment.
Comments
10 comments