MySQL啟動報錯:Starting MySQL.. ERROR! The server quit without updating PID file的問題分析和解決
更新時間：2023年12月07日 11:30:23 作者：清風的BLOG
這篇文章給大家介紹了MySQL啟動報錯:Starting MySQL.. ERROR! The server quit without updating PID file的問題分析和解決辦法,文中給出了詳細的原因分析,需要的朋友可以參考下
問題
[root@centos74 ~]# service mysqld start Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/mysqld.pid).
分析解決
1、 可能已經(jīng)存在 mysqld 進程.
[root@centos74 ~]# ps -ef | grep mysqld [root@centos74 ~]# pkill -9 mysqld # 查看是否有這個進程，如果有殺死掉
2、數(shù)據(jù)目錄mysql用戶是否有權(quán)限.
[root@centos74 ~]# chown -R mysql.mysql /usr/local/mysql/data
3、機器上面還有上次安裝mysql的殘留.
[root@centos74 ~]# find / -name mysql-binlog* # 查看mysql的二進制目錄，看是否存在mysqlbinlog.index,有的話刪掉
4、mysql 在啟動的時候會去尋找默認的 配置文件 /etc/my.cnf 這個目錄下的 datadir 要指定數(shù)據(jù)目錄.
# 如果沒有，那么在 my.cnf 里面添加 datadir=/usr/local/mysql/data
5、skip-federated字段問題.
# 檢查一下/etc/my.cnf文件中有沒有沒被注釋掉的skip-federated字段，如果有就立即注釋掉.
6、錯誤日志目錄不存在.
# 賦予 mysql 所有者權(quán)限 chmod chown .
7、防火墻原因.
# centos 會默認開啟selinux . [root@centos74 ~]# vim /etc/selinux/config SELINUX=disabled
8、查看配置文件/usr/local/mysql/my.cnf里有沒有innodb_buffer_pool_size
# innodb_buffer_pool_size：主要作用是緩存innodb表的索引，數(shù)據(jù)，插入數(shù)據(jù)時的緩沖. # 默認值：128M； # 專用mysql服務(wù)器設(shè)置此值的大?。?系統(tǒng)內(nèi)存的70%-80%最佳. # 如果你的系統(tǒng)內(nèi)存不大，查看這個參數(shù)，把它的值設(shè)置小一點.
10、關(guān)注 mysql 的報錯日志.
[root@centos74 /]# cd /usr/local/mysql/ [root@centos74 mysql]# cat mysql.err 190718 8:31:56 [Note] Plugin 'FEDERATED' is disabled. mysqld: Table 'mysql.plugin' doesn't exist 190718 8:31:56 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 190718 8:31:56 InnoDB: The InnoDB memory heap is disabled 190718 8:31:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190718 8:31:56 InnoDB: Compressed tables use zlib 1.2.11 190718 8:31:56 InnoDB: Using Linux native AIO 190718 8:31:56 InnoDB: Initializing buffer pool, size = 128.0M 190718 8:31:56 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 190718 8:31:56 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 190718 8:31:56 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 190718 8:31:56 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: 127 rollback segment(s) active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 190718 8:31:56 InnoDB: Waiting for the background threads to start 190718 8:31:57 InnoDB: 5.5.62 started; log sequence number 0 190718 8:31:57 [ERROR] mysqld: unknown option '--initialize' 190718 8:31:57 [ERROR] Aborting 190718 8:31:57 InnoDB: Starting shutdown... 190718 8:31:58 InnoDB: Shutdown completed; log sequence number 1595675 190718 8:31:58 [Note] mysqld: Shutdown complete 190718 8:32:07 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist 190718 8:32:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 190718 8:32:07 InnoDB: The InnoDB memory heap is disabled 190718 8:32:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190718 8:32:07 InnoDB: Compressed tables use zlib 1.2.11 190718 8:32:07 InnoDB: Using Linux native AIO 190718 8:32:07 InnoDB: Initializing buffer pool, size = 128.0M 190718 8:32:07 InnoDB: Completed initialization of buffer pool 190718 8:32:07 InnoDB: highest supported file format is Barracuda. 190718 8:32:07 InnoDB: Waiting for the background threads to start 190718 8:32:08 InnoDB: 5.5.62 started; log sequence number 1595675 190718 8:32:08 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 190718 8:32:08 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 190718 8:32:08 [Note] Server socket created on IP: '0.0.0.0'. 190718 8:32:08 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 190718 8:33:17 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist 190718 8:33:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 190718 8:33:17 InnoDB: The InnoDB memory heap is disabled 190718 8:33:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190718 8:33:17 InnoDB: Compressed tables use zlib 1.2.11 190718 8:33:17 InnoDB: Using Linux native AIO 190718 8:33:17 InnoDB: Initializing buffer pool, size = 128.0M 190718 8:33:17 InnoDB: Completed initialization of buffer pool 190718 8:33:17 InnoDB: highest supported file format is Barracuda. 190718 8:33:17 InnoDB: Waiting for the background threads to start 190718 8:33:18 InnoDB: 5.5.62 started; log sequence number 1595675 190718 8:33:18 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 190718 8:33:18 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 190718 8:33:18 [Note] Server socket created on IP: '0.0.0.0'. 190718 8:33:18 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 190718 8:36:58 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist 190718 8:36:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 190718 8:36:58 InnoDB: The InnoDB memory heap is disabled 190718 8:36:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190718 8:36:58 InnoDB: Compressed tables use zlib 1.2.11 190718 8:36:58 InnoDB: Using Linux native AIO 190718 8:36:58 InnoDB: Initializing buffer pool, size = 128.0M 190718 8:36:58 InnoDB: Completed initialization of buffer pool 190718 8:36:58 InnoDB: highest supported file format is Barracuda. 190718 8:36:58 InnoDB: Waiting for the background threads to start 190718 8:36:59 InnoDB: 5.5.62 started; log sequence number 1595675 190718 8:36:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 190718 8:36:59 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 190718 8:36:59 [Note] Server socket created on IP: '0.0.0.0'. 190718 8:36:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
以上就是MySQL啟動報錯:Starting MySQL.. ERROR! The server quit without updating PID file的問題分析和解決的詳細內(nèi)容，更多關(guān)于MySQL啟動報錯:Starting MySQL.. ERROR的資料請關(guān)注腳本之家其它相關(guān)文章！
相關(guān)文章
這篇文章主要介紹了MySQL索引命中與失效代碼實現(xiàn)，文章內(nèi)容詳細，簡單易懂,需要的朋友可以參考下2023-01-01
淺談MyISAM 和 InnoDB 的區(qū)別與優(yōu)化
InnoDB和MyISAM是在使用MySQL最常用的兩個表類型，各有優(yōu)缺點，視具體應(yīng)用而定。下面我們就來具體探討下吧2015-07-07
這篇文章主要給大家介紹了關(guān)于MySQL limit使用方法以及超大分頁問題解決的相關(guān)資料，文中通過示例代碼介紹的非常詳細，對大家的學習或者使用MySQL具有一定的參考學習價值，需要的朋友們下面來一起學習學習吧2019-10-10
Mysql 9.0.0創(chuàng)新MSI安裝的實現(xiàn)
本文提供了MySQL 9.0.0版本的MSI安裝方法,包括安裝前的下載鏈接,安裝過程中的選項介紹,以及安裝完成后的配置指南,具有一定的參考價值,感興趣的可以了解一下2024-10-10
編繹MySQL時一般以ISO-8859字符集作為默認的字符集，因此在比較過程中中文編碼字符大小寫轉(zhuǎn)換造成了這種現(xiàn)象，一種解決方法是對于包含中文的字段加上"binary"屬性，使之作為二進制比較2011-11-11
這篇文章主要為大家詳細介紹了Linux虛擬機下mysql 5.7安裝配置方法圖文教程，具有一定的參考價值，感興趣的小伙伴們可以參考一下2017-01-01
MySQL數(shù)據(jù)表從創(chuàng)建到管理操作大全
本文詳細介紹了MySQL數(shù)據(jù)表的創(chuàng)建、查看、修改和刪除操作,包括存儲引擎選擇、表結(jié)構(gòu)修改注意事項以及備份和測試的重要性,通過實例和實戰(zhàn)案例,幫助讀者掌握MySQL表的基本操作技巧,感興趣的朋友跟隨小編一起看看吧2026-02-02
MySQL修改表結(jié)構(gòu)操作命令總結(jié)
這篇文章主要介紹了MySQL修改表結(jié)構(gòu)操作命令總結(jié),包含如刪除列、添加列、修改列、添加主鍵、刪除主鍵、添加唯一索引、添加普通索引等內(nèi)容,需要的朋友可以參考下2014-12-12
這篇文章主要介紹了MySQL update set 和 and的區(qū)別，幫助大家更好的理解和學習使用MySQL數(shù)據(jù)庫，感興趣的朋友可以了解下2021-05-05
這篇文章主要為大家詳細介紹了Windows下mysql5.7.21安裝詳細教程，具有一定的參考價值，感興趣的小伙伴們可以參考一下2018-02-02