ibdata1
The innodb_system data file 'ibdata1' must be writable
MySQL无法启动 Active: deactivating (stop-sigterm) (Result: exit-code) 查看配置文件中的日志存储位置： view /etc/my.cnf 查看日志存储文件位置：/var/log/mysqld.log 文件错误提示：The innodb_sy ......
Table flags are 0 in the data dictionary but the flags in file ./ibdata1 are 0x4800!
# 1、问题截图 cat /var/log/mysql/error.log ``` sql 2019-01-28T09:49:57.076019Z 0 [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the f ......
[ERROR] [MY-012263] [InnoDB] The Auto-extending innodb_system data file './ibdata1' is of a different sizethan specified in the .cnf file: initial 65536 pages, max 0 (relevant if non-zero) pages!
实际my.cnf发现里面的innodb_data_file_path = ibdata1:1G:autoextend 设置得太大，我这机器容量小，所以调到12M ， innodb_data_file_path = ibdata1:12M:autoextend ......