问题原文
原帖链接 · MOtaro Site · CC BY-SA 3.0
I am not able to start MySQL , i am gettting this error
[root@server scripts]# service mysql start
Starting MySQL.The server quit without updating PID file (/[FAILED]mysql/server.mydomain.com.pid).
what should i do
I dont have any my.cnf file anywhere
only have these
/etc/pki/tls/openssl.cnf
/home/monty/.mylogin.cnf
/opt/rightscale/sandbox/openssl.cnf
/root/.mylogin.cnf
/usr/share/doc/MySQL-server-5.6.10/my-default.cnf
/usr/share/mysql/my-default.cnf
/var/lib/mysql/auto.cnf
已采纳解答
原帖链接 · Abhishek Anand Amralkar · CC BY-SA 4.0
In CentOS you need to copy /usr/share/doc/MySQL-server-5.6.10/my-default.cnf to /etc/my.cnf and you have to make changes in my.cnf as per your server configuration,after every changes in my.cnf to get reflect you need to restart you mysql server.
It seems you have issue with you permission on mysql datadir. Run below command
mysql_install_db
This command will check your mysql configuration and find out the errors . Once this is done
chown -R mysql:mysql /path to your mysql data dir ( default is /var/lib/mysql)
brew service mysql restart
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
