MySQL启动报错解决一例_MySQL
由于项目需要不得不折腾MySQL，RedHatLinux上安装了最新的MySQL 5.6启动报错如下：
[root@tserver mysql]# /etc/init.d/mysql start
Starting MySQL.The server quit without updating PID file (/var/lib/mysql/tserver.pid).[FAILED]
检查报错信息tserver.err。
cat tserver.err
140121 06:03:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-01-21 06:03:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-01-21 06:03:29 14964 [Note] Plugin 'FEDERATED' is disabled.
2014-01-21 06:03:29 14964 [Note] InnoDB: The InnoDB memory heap is disabled
2014-01-21 06:03:29 14964 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-01-21 06:03:29 14964 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-01-21 06:03:29 14964 [Note] InnoDB: Using Linux native AIO
2014-01-21 06:03:29 14964 [Note] InnoDB: Using CPU crc32 instructions
2014-01-21 06:03:29 14964 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-01-21 06:03:29 14964 [Note] InnoDB: Completed initialization of buffer pool
2014-01-21 06:03:29 14964 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2014-01-21 06:03:29 14964 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2014-01-21 06:03:29 14964 [ERROR] Plugin 'InnoDB' init function returned error.
2014-01-21 06:03:29 14964 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-01-21 06:03:29 14964 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-01-21 06:03:29 14964 [ERROR] Aborting
2014-01-21 06:03:29 14964 [Note] Binlog end
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'partition'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_METRICS'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_CMP'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'INNODB_TRX'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'BLACKHOLE'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'ARCHIVE'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'CSV'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'MEMORY'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'MRG_MYISAM'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'MyISAM'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'sha256_password'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'mysql_old_password'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'mysql_native_password'
2014-01-21 06:03:29 14964 [Note] Shutting down plugin 'binlog'
2014-01-21 06:03:29 14964 [Note] /usr/sbin/mysqld: Shutdown complete
检查发现mysql的目录下有如下文件：
[root@tserver mysql]# ls
ibdata1 ib_logfile0 ib_logfile1 mysql RPM_UPGRADE_HISTORY RPM_UPGRADE_MARKER-LAST test tserver.err
删除了如下三个文件：
[root@tserver mysql]# rm ibdata1 ib_logfile0 ib_logfile1
rm: remove regular file `ibdata1'? yes
rm: remove regular file `ib_logfile0'? yes
rm: remove regular file `ib_logfile1'? yes
重新启动mysql server就可以了：
[root@tserver mysql]# /etc/init.d/mysql start
Starting MySQL.[ OK ]
[root@tserver mysql]# ps -ef|grep mysql
root 15166 1 0 06:12 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/tserver.pid
mysql 15257 15166 9 06:12 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/tserver.err --pid-file=/var/lib/mysql/tserver.pid
root 15284 14224 0 06:12 pts/0 00:00:00 grep mysql
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Share an easy way to package PyCharm projects
Dec 30, 2023 am 09:34 AM
Share the simple and easy-to-understand PyCharm project packaging method. With the popularity of Python, more and more developers use PyCharm as the main tool for Python development. PyCharm is a powerful integrated development environment that provides many convenient functions to help us improve development efficiency. One of the important functions is project packaging. This article will introduce how to package projects in PyCharm in a simple and easy-to-understand way, and provide specific code examples. Why package projects? Developed in Python
Can AI conquer Fermat's last theorem? Mathematician gave up 5 years of his career to turn 100 pages of proof into code
Apr 09, 2024 pm 03:20 PM
Fermat's last theorem, about to be conquered by AI? And the most meaningful part of the whole thing is that Fermat’s Last Theorem, which AI is about to solve, is precisely to prove that AI is useless. Once upon a time, mathematics belonged to the realm of pure human intelligence; now, this territory is being deciphered and trampled by advanced algorithms. Image Fermat's Last Theorem is a "notorious" puzzle that has puzzled mathematicians for centuries. It was proven in 1993, and now mathematicians have a big plan: to recreate the proof using computers. They hope that any logical errors in this version of the proof can be checked by a computer. Project address: https://github.com/riccardobrasca/flt
A closer look at PyCharm: a quick way to delete projects
Feb 26, 2024 pm 04:21 PM
Title: Learn more about PyCharm: An efficient way to delete projects. In recent years, Python, as a powerful and flexible programming language, has been favored by more and more developers. In the development of Python projects, it is crucial to choose an efficient integrated development environment. As a powerful integrated development environment, PyCharm provides Python developers with many convenient functions and tools, including deleting project directories quickly and efficiently. The following will focus on how to use delete in PyCharm
PyCharm Practical Tips: Convert Project to Executable EXE File
Feb 23, 2024 am 09:33 AM
PyCharm is a powerful Python integrated development environment that provides a wealth of development tools and environment configurations, allowing developers to write and debug code more efficiently. In the process of using PyCharm for Python project development, sometimes we need to package the project into an executable EXE file to run on a computer that does not have a Python environment installed. This article will introduce how to use PyCharm to convert a project into an executable EXE file, and give specific code examples. head
How to Make a Shopping List in the iOS 17 Reminders App on iPhone
Sep 21, 2023 pm 06:41 PM
How to Make a GroceryList on iPhone in iOS17 Creating a GroceryList in the Reminders app is very simple. You just add a list and populate it with your items. The app automatically sorts your items into categories, and you can even work with your partner or flat partner to make a list of what you need to buy from the store. Here are the full steps to do this: Step 1: Turn on iCloud Reminders As strange as it sounds, Apple says you need to enable reminders from iCloud to create a GroceryList on iOS17. Here are the steps for it: Go to the Settings app on your iPhone and tap [your name]. Next, select i
What to do if there is an error when starting the react project
Dec 27, 2022 am 10:36 AM
Solution to the error when starting the react project: 1. Enter the project folder, start the project and view the error message; 2. Execute the "npm install" or "npm install react-scripts" command; 3. Execute "npm install @ant-design/ pro-field --save" command.
Based on the open source ChatGPT Web UI project, quickly build your own ChatGPT site
Apr 15, 2023 pm 07:43 PM
As a technology blogger, Fengfeng prefers all kinds of tossing. I have previously introduced ChatGPT to connect to WeChat, DingTalk and Knowledge Planet (if you haven’t seen it, you can read the previous article). Recently, when I looked at open source projects , discovered a ChatGPTWebUI project. Thinking that I have never connected ChatGPT to WebUI before, it is really good to have this open source project to use. Here are the practical installation steps to share with everyone. The installation official provides many installation methods on Github’s project documentation, including manual installation, docker deployment, and remote deployment. It’s amazing that when choosing a deployment method, I thought about simplicity at first.
Basic tutorial: Create a Maven project using IDEA
Feb 19, 2024 pm 04:43 PM
IDEA (IntelliJIDEA) is a powerful integrated development environment that can help developers develop various Java applications quickly and efficiently. In Java project development, using Maven as a project management tool can help us better manage dependent libraries, build projects, etc. This article will detail the basic steps on how to create a Maven project in IDEA, while providing specific code examples. Step 1: Open IDEA and create a new project Open IntelliJIDEA
