• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Cannot Open Plesk CP

K

Kevin Medri

Guest
Hi I have just run a yum upgrade on php and mysql from the atomicorp repository and now recieve this error message:
ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

0: common_func.php3:146
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)')
1: auth.php3:93
Also in ssh i cannot seem to start the service mysql, I am using command:
service mysqld start
This returns failed.
Also my sites cannot connect to database.
Any help would be great. Thank you.
 
Try to enable logging for MySQL in /etc/my.cnf if it is not enabled and try to find a reason why mysql cant be started in mysql log.
 
This is the error log when trying to start mysql:

100729 19:54:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100729 19:54:18 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
100729 19:54:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100729 19:54:18 InnoDB: Started; log sequence number 0 24297565
100729 19:54:18 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb'
100729 19:54:18 [ERROR] Aborting

100729 19:54:18 InnoDB: Starting shutdown...
100729 19:54:24 InnoDB: Shutdown completed; log sequence number 0 24297565
100729 19:54:24 [Note] /usr/libexec/mysqld: Shutdown complete

100729 19:54:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
 
Thank you, another error is:
can't connect to local mysql server through socket 'var/lib/mysql/mysql.sock'

the mysql.sock file is not there, is it possible to recreate it?
 
Back
Top