Editing my.cnf, failed to restart

basketmen

Well-Known Member
Sep 9, 2010
128
1
66
Dear guys, i want to editing /etc/my.cnf file

i try use this for the file content
[mysqld]
set-variable = max_allowed_packet=24M
set-variable = max_connections=300
log-slow-queries
safe-show-database
local-infile=0
open_files_limit=3980
then run restart mysql command
/etc/rc.d/init.d/mysql restart
but got failed message like this

[email protected] [~]# /etc/rc.d/init.d/mysql restart
Shutting down MySQL.... [ OK ]
Starting MySQL...The server quit without updating PID file (/var/lib/mysql/server1.domain.com.pid). [FAILED]


i read here /http://www.webhostingtalk.com/showthread.php?t=1114852 he says to change [mysqld] with [mysql]
but he is using Percona,
i am just using standart whm/cpanel installation, will it work too?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello :)

Please post the output from /var/lib/mysql/$hostname.err when restarting MySQL to see which specific value is causing it to fail.

Thank you.