sqlserver基本介紹，mysql 啟動報錯-server PID file could not be found

2023-10-07 阅读 26 评论 0

摘要：[root@yunhe ~]# service mysql stopMySQL server PID file could not be found!????????????????? [失敗] 解決方案如下：首先查看下與mysql有關的進程 [root@yunhe ~]# ps aux |grep mysq*root??????2019? 0.0? 0.1?? 6228? 1392 ???????? S??? 09:22?? 0:0

[root@yunhe ~]# service mysql stop
MySQL server PID file could not be found!????????????????? [失敗]

解決方案如下：

首先查看下與mysql有關的進程

[root@yunhe ~]# ps aux |grep mysq*
root??????2019? 0.0? 0.1?? 6228? 1392 ???????? S??? 09:22?? 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/yunhe.pid
mysql???? 2115??0.0? 2.9 353596 30808 ???????? Sl?? 09:22?? 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/yunhe.err --pid-file=/var/lib/mysql/yunhe.pid
500?????? 4258? 0.0? 1.6? 83432 17484 ???????? S??? 09:35?? 0:01 gedit /usr/share/mysql/my-medium.cnf
root????? 5555? 0.0? 0.0?? 5936?? 768 pts/0??? S+?? 10:04?? 0:00 grep mysq*

如果看到上面的內容，那說明mysql相關的進程存在，不過資源調度出現了問題（好像卡死），這時用就要把這些卡死的進程都關閉。
[root@yunhe ~]# kill 2019
[root@yunhe ~]# kill 20115
-bash: kill: (20115) - 沒有那個進程
[root@yunhe ~]# kill 2115

然后重新啟動mysql
[root@yunhe ~]# service mysql start
Starting MySQL...????????????????????????????????????????? [確定]
[root@yunhe ~]# mysql -u root -p
Enter password:?
Welcome to the MySQL monitor.? Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.4-m7 MySQL Community Server (GPL)

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>?

原文链接：https://hbdhgg.com/5/128054.html

上一篇：JAVA程序，【JAVA基礎】HashSet、LinkedHashSet、TreeSet使用區別

下一篇：Dangling meta character '?' near index 0