Urgent! database connection failed after update mysql 5.5 to 5.7

[pascal020]

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]

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]

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!