Resolved On 3 server with plesk I have ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002]

[Luc P]

I get the same problem on one of my server. The first one did an automatic update (5.5.52.36- of mysql this night (lucky me, the other was going to do it, I stopped this update).

Trying to reboot, same problem. Starting mysqld gives an error, but nothing in /var/log/mysqld.log

 

[René Stolp]

I may have found a solution:

The problem is a set of faulty update packages from the atomic repo. I just learnt that you can easily undo yum package updates in CentOS:

https://access.redhat.com/solutions/64069

So, look up the latest update transaction (should be easy, the last one with three changes) and do the undo, as outlined in the above article. Worked for me.

Cheers, René

 

[AirLink]

Solved by downgrading and restarting mysql:

yum downgrade mysql-libs mysql mysql-server
service mysqld start

 

[sebas]

Going back to mysql-5.5.52-36.el6.art.x86_64 mysql-devel-5.5.52-36.el6.art.x86_64 mysql-libs-5.5.52-36.el6.art.x86_64 mysql-server-5.5.52-36.el6.art.x86_64 solved it for me.

This is what I did:

Find the installed version
rpm -qa |grep mysql

Remove the "bad guy".
rpm -e mysql-5.5.54-36.x86_64 mysql-devel-5.5.54-36.x86_64 mysql-server-5.5.54-36.x86_64 mysql-libs-5.5.54-36.x86_64 --nodeps

Install the "old good friend".
yum install mysql-5.5.52-36.el6.art mysql-devel-5.5.52-36.el6.art mysql-server-5.5.52-36.el6.art mysql-libs-5.5.52-36.el6.art
yum check

Back to normal.
service mysqld start

 

[Luc P]

I resolved the problem downgrading the update.

On centos do yum history and check the update ID (by the hour of mysql update), then do yum history undo ID (where ID is the ID previously found). Then reboot.

 

[Sunucu Çözümleri]

Hi,
We are 10 plesk server Down.

Solved.

yum remove -y mysql
yum clean all
rpmdb --rebuilddb
yum update -y
wget -q -O - http://www.atomicorp.com/installers/atomic | sh
yum install -y mysql


nano -w /etc/my.cnf
skip-grant-tables

saved.

Good Jobs.

 

[IgorG]

Have anybody contacted Atomic support regarding this issue?

 

[ismail el moussati]

What a horrible update is this ? 7 websites all down ? also plesk admin down my gosh

 

[Gigaveri]

yum downgrade mysql-libs mysql mysql-server

service mysqld start

 

[Mik]

Another solution is to create the missing folder /var/lib/mysql-files
then chown mysql:mysql
this has solved the problem on 2 server
On the server 3 mysql is on and working but the plesk login has same error
something missing... dunno...
...about plesk no comment...

 

[IgorG]

...about plesk no comment...

I see that all of you have this problem with MySQL from Atomic repository. Here is workaround from Plesk - https://support.plesk.com/hc/en-us/articles/115001906725

 

[ismail el moussati]

Hi,
We are 10 plesk server Down.

Solved.

yum remove -y mysql
yum clean all
rpmdb --rebuilddb
yum update -y
wget -q -O - http://www.atomicorp.com/installers/atomic | sh
yum install -y mysql


nano -w /etc/my.cnf
skip-grant-tables

saved.

Good Jobs.

I used this with Plesk 17 not worked, now i don't have mysql installed, can i have any kb support to install mysql ! and start it please

 

[Mik]

we didnt have a problem with mysql, we had a problem with the plesk update that release mysql update without checking what was doing
thanks

 

[ismail el moussati]

yum downgrade mysql-libs mysql mysql-server

service mysqld start

Unrecognized service

 

[Matthias L]

Because i didn't find any one posting the official link for that issue from Plesk:

Please read: https://support.plesk.com/hc/en-us/articles/115001906725

I just run their command and everything is fine again:

install -m 0700 -o mysql -g mysql -d /var/lib/mysql-files

 

[damian]

Downgrade did not work, fixed it by upgrading the mysql to 5.6 following: https://support.plesk.com/hc/en-us/articles/213403429-How-to-upgrade-MySQL-5-5-to-5-6

 

[ismail el moussati]

What to do with this ? Also i can't acccess to Plesk admin,
502 Bad Gateway
NGINX
Thanks in advance

 

[sebas]

Have anybody contacted Atomic support regarding this issue?

I left a post on theirs support forum.