MySQL server PID file could not be found!
root@s1 Downloads]# service mysql restart
MySQL server PID file could not be found! [FAILED]
MySQL server PID file could not be found! [FAILED]
[root@s1 Downloads]# service mysql stop
MySQL server PID file could not be found! [FAILED]
解決方法:
1.透過ss -tnl命令檢視服務
[root@s1 Downloads]# ss -tnl
State Recv-Q Send-Q Local Address:Port Peer Address:Port
LISTEN 0 50 *:3306 *:*
2,停止mysql服務
[root@s1 Downloads]# killall mysqld
3.重啟mysql服務
4.發現mysql資料目錄許可權異常
[root@s1 Downloads]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
5.修改mysql資料目錄許可權
[root@s1 Downloads]# chown -R mysql.mysql /var/lib/mysql/
6.重啟服務,即可以正常登陸mysql
MySQL server PID file could not be found! [FAILED]
解決方法:
1.透過ss -tnl命令檢視服務
[root@s1 Downloads]# ss -tnl
State Recv-Q Send-Q Local Address:Port Peer Address:Port
LISTEN 0 50 *:3306 *:*
2,停止mysql服務
[root@s1 Downloads]# killall mysqld
4.發現mysql資料目錄許可權異常
[root@s1 Downloads]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
5.修改mysql資料目錄許可權
[root@s1 Downloads]# chown -R mysql.mysql /var/lib/mysql/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30046312/viewspace-2142901/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MysqL錯誤之_ERROR! MySQL server PID file could not be found!MySqlErrorServer
- Mysql啟動錯誤-server PID file could not be foundMySqlServer
- ERROR! The server quit without updating PID file (/opt/mysql/mysql/data/cvs.pid)ErrorServerUIMySql
- The server quit without updating PID file (/mydata/mysql/BIDB.pid).[FAILED]ServerUIMySqlAI
- Mysql:The server quit without updating PID file (/eipdb1/mysql/data/EIPDB1.pid).MySqlServerUI
- MySQL提示:The server quit without updating PID file(…)失敗MySqlServerUI
- Starting MySQL.The server quit without updating PID fileMySqlServerUI
- MySQL啟動報錯:The server quit without updating PID fileMySqlServerUI
- The server quit without updating PID fileServerUI
- MySQL The server quit without updating PID file xx/var/DESKTOP-BHVUG0D.pidMySqlServerUI
- mysql RSA private key file not foundMySql
- The server quit without updating PID file (/var/mysqltest1.pid).[FAILEDServerUIMySqlAI
- mysql The server quit without updating PID file異常解決辦法薦MySqlServerUI
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- CDH CM cloudera-scm-server dead but pid file existsCloudServer
- mysql中出現Unit mysql.service could not be found 的解決方法MySql
- 【MySQL】mysql啟動常見報錯 mysqld_safe mysqld from pid file hostname.pid endedMySql
- Linux安裝mysql出現ERROR! The server quit without updating PID file問題解決LinuxMySqlErrorServerUI
- MYSQL啟動後報:ERROR! The server quit without updating PID file錯誤的問題解決MySqlErrorServerUI
- mysql啟動報錯Manager of pid-file quit without updating file.[FAILED]MySqlUIAI
- Error 15: File not found for RedhatErrorRedhat
- jmap -dump:format=b,file=java_pid_04180.hprof pidORMJava
- file not found WFMLRSVCApp.earAPP
- Could not find first log file name in binary log index fileIndex
- The requested URL was not found on the serverServer
- Oracle Management Server Could Not Be StartedOracleServer
- Newline required at end of file but not foundUI
- can't create PID file問題處理
- kattle Driver class 'oracle.jdbc.driver.OracleDriver' could not be foundOracleJDBC
- vue3 Could not find a declaration file for moduleVue
- boot VMware server no found local?bootServer
- mysql之pid檔案MySql
- More than one file was found with OS independent path
- What Is a Server Parameter File?Server
- Android:Unexpected lock protocol found in lock file. Expected 3, found 0.AndroidProtocol
- Mysql 報The MySQL server is running with the --secure-file-priv option so it cannot execute this stat...MySqlServer
- ERROR 1290:The MySQL server is running with the --secure-file-priv optionErrorMySqlServer
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase