• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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