mysqld状态显示已停止,但实际运行

egdjgwm8  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(305)

我使用centos6 hortonworks沙盒。当我跑步时:

[root@sandbox-hdp ~]# service mysqld stop

它停了,我检查了一下:

[root@sandbox-hdp ~]# service mysqld status
mysqld is stopped

到目前为止一切都很好。但当我试着从这个开始时:

[root@sandbox-hdp ~]# service mysqld start
Starting mysqld:                                           [  OK  ]

我又查了一遍:

[root@sandbox-hdp ~]# service mysqld status
mysqld is stopped

但奇怪的事情正在发生:

[root@sandbox-hdp ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5486
Server version: 5.6.39 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

我不明白怎么会这样?

xsuvu9jc

xsuvu9jc1#

​我解决了。我学习mysqld pid的方法是:

top

​然后杀了它

kill 24678

​我开始了mysqld:

service start mysqld

问题是:

service mysqld stop

​无法阻止mysqld。

相关问题