• 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

mysqld can't start

I

ittec

Guest
Hi all

this is my first post, so hello to all members.

Im admin of a "old" Plesk. I think it 7.5 version, but im not sure. I have access to server by SSH and not by web because MYSQL its off.

When i try to reboot MYSQL in SSH console, the system returns:

Code:
Stopping MySQL:                                    

[COLOR=red][FAILED][/COLOR]

Timeout error occurred trying to start MySQL Daemon.

If a try to enter by web i see this:

Code:
ERROR: Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0:

/usr/local/psa/admin/auto_prepend/auth.php3:81 psaerror(string "Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")

Perhaps the error is by MYSQL setup, but im not sure. I rembember that i modified my.cnf few days ago

MYSQL setup:
Code:
[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=400
max_connect_errors=999999

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Can anyone help me? Im looking for mysql error log, but i dont' find it.

Thanks.
 
Well,

finally i found mysql log and saw error. Alls works now.

InnoDb setup in my.cnf was the problem.

Thanks.
 
Back
Top