启动Mysql时报如下错误[root@VM_26_56_Centos data]# service mysqld start Starting Mysql.
启动Mysql时报如下错误
[root@VM_26_56_Centos data]# service mysqld start
Starting Mysql.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/VM_26_56_centos.pid).
查看日志显示
2017-03-14 15:49:28 27467 [Note] Server hostname (bind-address): '*'; port: 3306
2017-03-14 15:49:28 27467 [Note] IPv6 is not available.
2017-03-14 15:49:28 27467 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2017-03-14 15:49:28 27467 [Note] Server Socket created on IP: '0.0.0.0'.
2017-03-14 15:49:28 27467 [ERROR] Can't start server: Bind on tcp/IP port: Address already in use
2017-03-14 15:49:28 27467 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-03-14 15:49:28 27467 [ERROR] Aborting
查看端口和进程
[root@VM_26_56_centos data]# netstat -tulnp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 23115/mysqld
[root@VM_26_56_centos data]# ps aux | grep 23115
root 17317 0.0 0.0 103252 892 pts/0 S+ 10:58 0:00 grep 23115
mysql 23115 0.0 1.6 3337908 540464 ? Sl Feb22 22:20 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/VM_26_56_centos.err --pid-file=/usr/local/mysql/data/VM_26_56_centos.pid
[root@VM_26_56_centos data]#
kill掉再次启动
[root@VM_26_56_centos local]# ps aux | grep 23115
root 17434 0.0 0.0 103252 892 pts/0 S+ 11:00 0:00 grep 23115
[root@VM_26_56_centos local]# service mysqld start
Starting MySQL. SUCCESS!
--结束END--
本文标题: MySQL数据库启动报The server quit without updating PID file
本文链接: https://www.lsjlt.com/news/38726.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0