mysql啟動報錯Manager of pid-file quit without updating file.[FAILED]
linux採用rpm方式安裝mysql,預設都裝到根目錄下了,需要將其安裝路徑挪到/data目錄;
遷完後Mysql啟動時候報告錯誤,找不到pid檔案
[root@testdb2 oracle]# service mysql start
Starting MySQL..Manager of pid-file quit without updating file.[FAILED]
此時需要採用safe模式啟動
[root@testdb2 oracle]# which mysqld_safe
/usr/bin/mysqld_safe
[root@testdb2 oracle]# /usr/bin/mysqld_safe --user=mysql&
[1] 7301
[root@testdb2 oracle]# 110801 15:33:40 mysqld_safe Logging to '/var/lib/mysql/testdb2.err'.
110801 15:33:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
此時可以登入mysql
[root@testdb2 oracle]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.51 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> exit
Bye
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15480802/viewspace-703709/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL啟動報錯:The server quit without updating PID fileMySqlServerUI
- MySQL提示:The server quit without updating PID file(…)失敗MySqlServerUI
- MySQL The server quit without updating PID file xx/var/DESKTOP-BHVUG0D.pidMySqlServerUI
- Linux安裝mysql出現ERROR! The server quit without updating PID file問題解決LinuxMySqlErrorServerUI
- 升級到 MySQL 8.4,MySQL 啟動報錯:io_setup() failed with EAGAINMySqlAI
- 上傳報錯:Upload Failed: Your upload has failed a virus scan. Please choose another file.AI
- ElasticSearch啟動報錯 ERROR: [4] bootstrap checks failedElasticsearchErrorbootAI
- 啟動IDEA 報 failed to load jvm dll XXX 錯誤IdeaAIJVM
- Vue 啟動專案報錯 Failed to compile with 2 errorsVueAICompileError
- Mysql啟動報錯:Job for mysqld.service failed because the control process exited with error code.MySqlAIError
- IDEA啟動時報Failed to create JVM錯誤的解決IdeaAIJVM
- SDK Manager:failed to installAI
- 報錯install_driver(mysql) failed: Attempt to reload DBD/mysql.pmMySqlAI
- Docker Desktop啟動報錯:Failed to set version to docker-desktop: exit code: -1DockerAI
- PyCharm啟動報錯:Failed to create JVM.解決辦法之一PyCharmAIJVM
- MySQL 啟動報錯 error while loading shared librariesMySqlErrorWhile
- innodb_undo_tablespaces導致Mysql啟動報錯MySql
- 安裝MySQL5.7報錯:The action ‘Install’ for product ‘MySQL Server 5.7.19’ failed.MySqlServerAI
- 如何啟動Redis ManagerRedis
- 解決啟動Tomcat報錯:Failed to destroy end point associated with ProtocolHandler["ajp-nio-8009"]TomcatAIProtocol
- myeclipse啟動報錯Eclipse
- zabbix報錯fping failed:no outputAI
- OGG Director報錯 Connection FAILEDAI
- Windows 啟動 Idea 報錯 if you already hava a 64-bit JDK ... 以及 failed to create jvm...WindowsIdeaJDKAIJVM
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- 記一次令人絕望的mysql啟動報錯MySql
- 啟動mysql報錯“服務沒有響應控制功能”MySql
- Homestead 啟動 elasticsearch 報錯Elasticsearch
- 本地nacos啟動報錯
- 解決Tomcat啟動報錯問題:Failed to destroy end point associated with ProtocolHandler["ajp-nio-8009"]TomcatAIProtocol
- PHP composer 報錯 certificate verify failedPHPAI
- IDEA 報錯Failed to load JVM DLLIdeaAIJVM
- SQLServer映象報錯Connection handshake failedSQLServerAI
- 求助:移動端登入測試,報錯 RemoteDisconnected Remote end closed connection without response。REM
- FATAL - Fatal error: Target Interaction Manager failed at StartupErrorAI
- 處理mysql無法啟動且啟動時服務沒報錯的異常情況MySql
- 啟動idea時, 碰到"failed to load jvm DLL ..."錯誤 解決方案IdeaAIJVM
- Mac 上啟動 appium 報錯MacAPP
- apache啟動報錯:httpd: aprApachehttpd