Starting MySQL.The server quit without updating PID file
今天下載了一個mysql5.7.18原始碼,裝著玩,沒想到安裝了一上午都沒有完成,不停報錯,最後發現竟然是錯誤日誌許可權導致的。真是魔鬼藏在細節中啊。重要的事情說三遍:注意細節,注意細節,注意細節!!
[root@mysql5-7-18 ~]# chown root:root /usr/local/mysql/log/mysql_mysql-5-7-18.err
[root@mysql5-7-18 ~]# ll /usr/local/mysql/log/
total 40
-rwxr-xr-x. 1 root root 9357 May 31 14:13 mysql_mysql-5-7-18.err
-rwxr-xr-x. 1 mysql mysql 177 May 31 11:33 ray-bin.000001
-rwxr-xr-x 1 mysql mysql 177 May 31 14:05 ray-bin.000002
-rwxr-xr-x 1 mysql mysql 177 May 31 14:07 ray-bin.000003
-rwxr-xr-x 1 mysql mysql 177 May 31 14:09 ray-bin.000004
-rwxr-xr-x 1 mysql mysql 573 May 31 14:13 ray-bin.000005
-rwxr-xr-x 1 mysql mysql 180 May 31 14:09 ray-bin.index
-rwxr-xr-x. 1 mysql mysql 925 May 31 14:09 slow-log.log
[root@mysql5-7-18 docs]# service mysqld start
Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/data/mysql5-7-18.pid).
[root@mysql5-7-18 ~]# chown mysql:mysql /usr/local/mysql/log/mysql_mysql-5-7-18.err
[root@mysql5-7-18 ~]# ll /usr/local/mysql/log/
total 40
-rwxr-xr-x. 1 mysql mysql 9357 May 31 14:13 mysql_mysql-5-7-18.err
-rwxr-xr-x. 1 mysql mysql 177 May 31 11:33 ray-bin.000001
-rwxr-xr-x 1 mysql mysql 177 May 31 14:05 ray-bin.000002
-rwxr-xr-x 1 mysql mysql 177 May 31 14:07 ray-bin.000003
-rwxr-xr-x 1 mysql mysql 177 May 31 14:09 ray-bin.000004
-rwxr-xr-x 1 mysql mysql 573 May 31 14:13 ray-bin.000005
-rwxr-xr-x 1 mysql mysql 180 May 31 14:09 ray-bin.index
-rwxr-xr-x. 1 mysql mysql 925 May 31 14:09 slow-log.log
[root@mysql5-7-18 ~]# service mysqld start
Starting MySQL.. [ OK ]
[root@mysql5-7-18 ~]#
[root@mysql5-7-18 ~]# chown root:root /usr/local/mysql/log/mysql_mysql-5-7-18.err
[root@mysql5-7-18 ~]# ll /usr/local/mysql/log/
total 40
-rwxr-xr-x. 1 root root 9357 May 31 14:13 mysql_mysql-5-7-18.err
-rwxr-xr-x. 1 mysql mysql 177 May 31 11:33 ray-bin.000001
-rwxr-xr-x 1 mysql mysql 177 May 31 14:05 ray-bin.000002
-rwxr-xr-x 1 mysql mysql 177 May 31 14:07 ray-bin.000003
-rwxr-xr-x 1 mysql mysql 177 May 31 14:09 ray-bin.000004
-rwxr-xr-x 1 mysql mysql 573 May 31 14:13 ray-bin.000005
-rwxr-xr-x 1 mysql mysql 180 May 31 14:09 ray-bin.index
-rwxr-xr-x. 1 mysql mysql 925 May 31 14:09 slow-log.log
[root@mysql5-7-18 docs]# service mysqld start
Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/data/mysql5-7-18.pid).
[root@mysql5-7-18 ~]# chown mysql:mysql /usr/local/mysql/log/mysql_mysql-5-7-18.err
[root@mysql5-7-18 ~]# ll /usr/local/mysql/log/
total 40
-rwxr-xr-x. 1 mysql mysql 9357 May 31 14:13 mysql_mysql-5-7-18.err
-rwxr-xr-x. 1 mysql mysql 177 May 31 11:33 ray-bin.000001
-rwxr-xr-x 1 mysql mysql 177 May 31 14:05 ray-bin.000002
-rwxr-xr-x 1 mysql mysql 177 May 31 14:07 ray-bin.000003
-rwxr-xr-x 1 mysql mysql 177 May 31 14:09 ray-bin.000004
-rwxr-xr-x 1 mysql mysql 573 May 31 14:13 ray-bin.000005
-rwxr-xr-x 1 mysql mysql 180 May 31 14:09 ray-bin.index
-rwxr-xr-x. 1 mysql mysql 925 May 31 14:09 slow-log.log
[root@mysql5-7-18 ~]# service mysqld start
Starting MySQL.. [ OK ]
[root@mysql5-7-18 ~]#
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28572479/viewspace-2140091/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- The server quit without updating PID fileServerUI
- MySQL提示:The server quit without updating PID file(…)失敗MySqlServerUI
- The server quit without updating PID file (/var/mysqltest1.pid).[FAILEDServerUIMySqlAI
- MySQL啟動報錯:The server quit without updating PID fileMySqlServerUI
- The server quit without updating PID file (/mydata/mysql/BIDB.pid).[FAILED]ServerUIMySqlAI
- ERROR! The server quit without updating PID file (/opt/mysql/mysql/data/cvs.pid)ErrorServerUIMySql
- 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 file (/eipdb1/mysql/data/EIPDB1.pid).MySqlServerUI
- mysql啟動報錯Manager of pid-file quit without updating file.[FAILED]MySqlUIAI
- Linux安裝mysql出現ERROR! The server quit without updating PID file問題解決LinuxMySqlErrorServerUI
- MYSQL啟動後報:ERROR! The server quit without updating PID file錯誤的問題解決MySqlErrorServerUI
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase
- MySQL server PID file could not be found!MySqlServer
- Mysql啟動錯誤-server PID file could not be foundMySqlServer
- MysqL錯誤之_ERROR! MySQL server PID file could not be found!MySqlErrorServer
- CDH CM cloudera-scm-server dead but pid file existsCloudServer
- jmap -dump:format=b,file=java_pid_04180.hprof pidORMJava
- Starting httpd: httpd: Could not reliably determine the serverhttpdServer
- can't create PID file問題處理
- Inline Workers--Web workers without a separate Javascript fileinlineWebJavaScript
- What Is a Server Parameter File?Server
- 【MySQL】mysql啟動常見報錯 mysqld_safe mysqld from pid file hostname.pid endedMySql
- err_quit()UI
- Exporting the Server Parameter FileExportServer
- Errors and Recovery for the Server Parameter FileErrorServer
- Starting MySQL * Couldn't find MySQL server (/usr/bin/mysqld_safe)MySqlServer
- nginx: [error] open() “/var/run/nginx/nginx.pid“ failed (2: No such file or directory)NginxErrorAI
- Migrating to a Server Parameter FileServer
- python,開發錯誤一:SyntaxError: Non-UTF-8 code starting with '\xca' in filePythonError
- Starting sendmial: make: Warning: File 'virtusertable.db' has ..的解決辦法2
- Install 11.2/12.1 DB/Client in Silent Mode without Using Response File _885643.1client
- 解決 "last line of file ends without a newline" 警告的方法:使用 .editorconfigAST
- Establishing SSL connection without server's identity verification is not recommended.ServerIDE
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Description of restoring file and filegroup backups in SQL ServerRESTSQLServer
- Step 5: Create a Server Parameter File (Recommended) (63)Server
- Starting & Stopping SAP