Issue Zend_Db_Adapter_Exception / Unable to start MYSQL

[groupedmx]

Hello,

Since an update, can not launch PLESK, and MYSQL service.

I followed all the posts of the forum, but nothing helps.

Could someone help me, I'm really embarrassed.

Thank you

 

[IgorG]

Could you please rewrite your question in English, default language of this forum?
Thanks.

 

[groupedmx]

Nobody to help me? I am really stuck :-(

Some new elements:
By dint of testing things, I ended up modifying the file my.cnf at the level of the bind-address, adding 127.0.0.1 on the line which was however in 0.0.0.0 and there I managed to return! uncomfortable !!
Then I made a reboot ... and there ... same problem income. and nothing helps!
I am totally lost, I have very important files on the server that I can not lose, I made backups, but using the module of plesk (on a backup server delivered with the main server at OVH, so only accesses the main server) so without a plesk that works I can not restore.

Can someone help me...

PS: sorry for my english ... google traduction ...

 

[WebHostingAce]

What is the output of

#journalctl -u mysql

 

[groupedmx]

 

[WebHostingAce]

What is the result of

#journalctl -xn

 

[groupedmx]

 

[WebHostingAce]

Please post your content of,

#vi /etc/my.cnf

 

[groupedmx]

I don't have /etc/my.cnf but /etc/mysql/my.cnf

 

[WebHostingAce]

change the to,

bind-address = 127.0.0.1

Save then restart mysql.

 

[groupedmx]

already, I just saw a typo: 217 instead of 127!
But even leaving only 127.0.0.1, mysql does not demmare

 

[WebHostingAce]

I'm not sure, I can see your mysql service is working now.

https://plesk.groupe-dmx.fr:8443

It was not working before.

 

[groupedmx]

just tested differently and it starts!
But I'm afraid that by rebooting it will not crash again ...

 

[groupedmx]

what i do not understand is that the bind-address has always been on 0.0.0.0 before and it worked fine

 

[WebHostingAce]

I don't think it will crash.

 

[WebHostingAce]

You can have

bind-address = 0.0.0.0

Or

bind-address = 127.0.0.1

NOT
bind-address = 0.0.0.0,127.0.0.1

 

[groupedmx]

I have just done different tests,
I put the bind-address in 0.0.0.0 and I manage to restart the MYSQL.
But if I delete the line skip-grant-tables (which I added for my tests and which does not normally exist) can not restart.

 

[WebHostingAce]

Did you upgrade MySQL before this issue started?

 

[groupedmx]

I have tried so many solutions that I do not really know what has been updated, but I do not think I made a direct update to MYSQL, but I do all the updates that are provided directly by PLESK

 

[groupedmx]

I retested several times, I rebooted several times, redone the latest updates, everything seems OK except the my.cnf file in which I have to leave skyp-grant-tables to be able to start MySQL.