My Oracle Support Banner

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
Generic Linux


MySQL fails to start after the following sequence of steps:

  1. Install MySQL
  2. Initialize MySQL (mysqld --initialize or mysql_install_db)
  3. Change the value of innodb_data_file_path in the MySQL configuration file.
  4. 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.