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提示:The server quit without updating PID file(…)失敗MySqlServerUI
- MySQL The server quit without updating PID file xx/var/DESKTOP-BHVUG0D.pidMySqlServerUI
- MySQL啟動報錯:The server quit without updating PID fileMySqlServerUI
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- go tool compile 報錯 could not import sync (file not found)GoCompileImport
- WebLogic啟動報Could not get the server file lockWebServer
- mysql RSA private key file not foundMySql
- Linux安裝mysql出現ERROR! The server quit without updating PID file問題解決LinuxMySqlErrorServerUI
- mysql中出現Unit mysql.service could not be found 的解決方法MySql
- Newline required at end of file but not foundUI
- ERROR 1290:The MySQL server is running with the --secure-file-priv optionErrorMySqlServer
- vue3 Could not find a declaration file for moduleVue
- 2.No appenders could be found for logger(log4j)APP
- Android:Unexpected lock protocol found in lock file. Expected 3, found 0.AndroidProtocol
- VueX Vue: Could not find a declaration file for module vuex.Vue
- More than one file was found with OS independent path
- React Native 報錯 'config.h' file not foundReact Native
- a commponent required a bean of type XXXXXX that could not be found-2022新專案UIBean
- mac mysql: command not foundMacMySql
- MySQL案例04:Cause: java.sql.SQLException: Could not retrieve transaction read-only status from serverMySqlJavaExceptionServer
- nginx: [error] open() “/var/run/nginx/nginx.pid“ failed (2: No such file or directory)NginxErrorAI
- HV000030: No validator could be found for constraint ‘javax.validation.constraints.Pattern‘ validatiAIJava
- Mac -bash: mysql: command not foundMacMySql
- MySQL啟動建立不了pid怎麼辦MySql
- MySQL中的pid與socket是什麼?MySql
- sqlserver bulk insert報錯Cannot bulk load because the file could not be opened.SQLServer
- centos 7 -bash: mysql: command not foundCentOSMySql
- 【ASM】Oracle RAC css啟動報錯"Duplicate voting file found"ASMOracleCSS
- 排查qt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found.QTPluginPlatform
- PID
- Kettle: pentaho-server-ce-9.4 : ERROR [SchemaUpdate] could not get database metadataServerErrorDatabase
- mac php8安裝swoole 'pcre2.h' file not foundMacPHP
- MySQL:Lost connection to MySQL server at 'readingMySqlServer
- Could not autowire. No beans of 'OrderService' type found. less... (Ctrl+F1) Inspection info:ChecksBean
- PID控制
- MySQL Server Startup ScriptMySqlServer
- Mysql修改server uuidMySqlServerUI
- Could not load file or assembly or one of its dependencies 試圖載入格式不正確的程式
- 解決:Could not load dynamic library ‘cudart64_101.dll‘; dlerror: cudart64_101.dll not foundDartError