Editing my.cnf, failed to restart
Dear guys, i want to editing /etc/my.cnf file
i try use this for the file content
[QUOTE][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 [QUOTE]/etc/rc.d/init.d/mysql restart
but got failed message like this [QUOTE]root@server1 [~]# /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). [[COLOR="#FF0000">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?
then run restart mysql command [QUOTE]/etc/rc.d/init.d/mysql restart
but got failed message like this [QUOTE]root@server1 [~]# /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). [[COLOR="#FF0000">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?
-
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. 0
Please sign in to leave a comment.
Comments
1 comment