程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> mysql啟動報錯-server PID file could not be found解決

mysql啟動報錯-server PID file could not be found解決

編輯:MySQL綜合教程


mysql啟動報錯-server PID file could not be found解決   [root@yunhe ~]# service mysql stop MySQL server PID file could not be found!                  [失敗]   www.2cto.com   解決方案如下:   首先查看下與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   www.2cto.com   然後重新啟動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)   Copyright (c) 2000, 2011, 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>   

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved