Urgent! database connection failed after update mysql 5.5 to 5.7

pascal020

Verified User
Joined
Jun 27, 2017
Messages
5
Hello,

For our live website we need to get it running as soon as possible.

We updated mysql 5.5 to 5.7 and after the update we could not connect to the database anymore.

In directadmin > Domain and SQL managment we get "Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) "

We tried a backup restore but then got a message:

"Error connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) "

Thanks
 

Zhenyapan

Verified User
Joined
Feb 23, 2018
Messages
403
Location
UA
service monitor shows that mysql works?
if not - check via ssh mysql status/logs
maybe you must check your my.cnf - there may be some strings incompatible with new version.
 

pascal020

Verified User
Joined
Jun 27, 2017
Messages
5
We got it working now. Not sure about the solution but it was some kind of mismatch with 5.5 to 5.7 sockets path

Thanks!
 
Top