如题 在更改my.cnf的pid和sock之后无法启动mysql了
1.输入:/etc/init.d/mysql restart
Stopping MySQL database server mysqld [fail]
Starting MySQL database server mysqld [fail]
2.输入:
3.输入:ps aux |grep mysqld
3271 0.0 0.0 4448 1704 pts/12 S 15:31 0:00 /bin/sh /usr/bin/mysqld_safe
tender 3630 0.0 1.4 550108 57740 pts/12 Sl 15:31 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=/var/log/mysql/error.log --pid-file=/var/lib/mysql/mysql.pid --socket=/var/lib/mysql/mysql.sock --port=3306
root 5978 0.0 0.0 15964 2176 pts/18 S+ 15:49 0:00 grep --color=auto mysqld
4.error log的显示:
mysqld_safe A mysqld process already exists
5.找到进程(如3)并杀死之后: 换了一个pid再次出现.
6.sudo service stop和start是正常的 分别显示mysql stop/waitting和mysql start/running.但是etc/init.d/mysql status 仍然会显示 MySQL stopped
The problem has been solved. When changing my.cnf, please change debian.cnf together