mysql 更改pid和sock位置之后无法启动
大家讲道理
大家讲道理 2017-04-17 14:21:21
0
2
423

如题 在更改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

大家讲道理
大家讲道理

光阴似箭催人老,日月如移越少年。

reply all(2)
PHPzhong

A mysqld process already exists
A mysqld process already exists. It means that the previous mysqld was not shut down, and then you started another one. So you know what to do.

小葫芦

The problem has been solved. When changing my.cnf, please change debian.cnf together

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!