Resolved MySQL Daemon failed to start.

[Szer0P]

Hello everyone,

iam facing a problem with mysql, i use plesk onyx and today i got this error and i cant open the plesk control panel
when i try to open the control panel i got this error

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Abstract.php:144)

Search for related Knowledge Base articles

ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$ta...', Array) #1 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('select param, v...', Array) #4 /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query('select param, v...', Array) #5 /usr/local/psa/admin/plib/db.php(36): Db_Adapter_Pdo_Mysql->query('select param, v...') #6 /usr/local/psa/admin/plib/db.php(212): db_query('select param, v...', false) #7 /usr/local/psa/admin/plib/Plesk/Mode.php(4 (Abstract.php:144)

Search for related Knowledge Base articles

when i try to open a wordpress website i got this error
Error establishing a database connection

i cant start or restart mysqld service .. i got this error

MySQL Daemon failed to start.

mysql log file:

170313  2:14:52 [Warning] IP address '171.92.208.42' could not be resolved: Name or service not known
170313  3:37:31 [Warning] IP address '117.44.27.52' could not be resolved: Name or service not known
170313  8:29:52 [Warning] IP address '60.191.38.78' could not be resolved: Name or service not known
170313 12:16:37 [Warning] IP address '49.4.142.178' could not be resolved: Name or service not known
170313 21:46:19 [Warning] IP address '61.144.56.37' could not be resolved: Name or service not known
170314  0:33:52 [Warning] IP address '49.4.142.64' could not be resolved: Name or service not known
170314  3:58:24 [Warning] IP address '137.59.18.168' could not be resolved: Name or service not known
170314  4:17:29 [Note] /usr/libexec/mysqld: Normal shutdown

170314  4:17:29 [Note] Event Scheduler: Purging the queue. 0 events
170314  4:17:31 [Warning] /usr/libexec/mysqld: Forcing close of thread 139587  user: 'admin'

170314  4:17:31 [Warning] /usr/libexec/mysqld: Forcing close of thread 139581  user: 'admin'

170314  4:17:31 [Warning] /usr/libexec/mysqld: Forcing close of thread 139579  user: 'admin'

170314  4:17:31 [Warning] /usr/libexec/mysqld: Forcing close of thread 139574  user: 'admin'

170314  4:17:31  InnoDB: Starting shutdown...
170314  4:17:32  InnoDB: Waiting for 3 pages to be flushed
170314  4:17:33  InnoDB: Shutdown completed; log sequence number 132064304951
170314  4:17:33 [Note] /usr/libexec/mysqld: Shutdown complete

170314 04:17:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

i tried to make this steps like this artikel but i coudnt solve the problem
https://support.plesk.com/hc/en-us/...SQLSTATE-HY000-2002-No-such-file-or-directory

when i tried to enter this:
grep pdo_mysql /usr/local/psa/admin/conf/php.ini
i got nothing, its not like the solution

[root@server ~]# grep pdo_mysql /usr/local/psa/admin/conf/php.ini
[root@server ~]# ps ax | grep mysql.sock | grep -v grep
[root@server ~]# grep socket /etc/my.cnf
socket=/var/lib/mysql/mysql.sock
[root@server ~]# grep -i socket /etc/psa/psa.conf
MYSQL_SOCKET /var/lib/mysql/mysql.sock
[root@server ~]# grep -i mysqld /var/spool/cron/*
[root@server ~]# /etc/init.d/sw-engine restart
sw-engine-fpm beenden:                                     [  OK  ]
sw-engine-fpm starten:                                     [  OK  ]
[root@server ~]# /etc/init.d/sw-cp-server restart
sw-cp-serverd beenden:                                     [  OK  ]
sw-cp-serverd starten:                                     [  OK  ]
[root@server ~]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]
[root@server ~]#

any idea?

thanks in advance!

 

[UFHH01]

Hi Szer0P,

did you see this thread: => https://talk.plesk.com/threads/on-3...adapter_exception-sqlstate-hy000-2002.342122/ ( especially: => #31 )

 

[Szer0P]

Hallo UFHH01,

vielen Dank für deine Hilfe .. ich habe das Problem mit einem Befehl gelöst ..
Die Lösung war in diesem Beitrag.
https://support.plesk.com/hc/en-us/articles/115001906725

Liebe Grüße.