After Initializing the Database, the mysqld Service Will Not Start: "[ERROR] InnoDB: The Auto-extending innodb_system data file '/var/lib/mysql/ibdata1' is of a different size ... than specified in the .cnf file: ..."
(Doc ID 2247096.1)
Last updated on MARCH 05, 2020
Applies to:MySQL Server - Version 5.6 and later
MySQL fails to start after the following sequence of steps:
- Install MySQL
- Initialize MySQL (mysqld --initialize or mysql_install_db)
- Change the value of innodb_data_file_path in the MySQL configuration file.
- Attempt to start the mysqld service
If MySQL is started using systemd, the output from systemctl will be similar to:
MySQL's datadir was initialized and innodb_data_file_path was changed.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document