请教:CentOS 下 Mysql 无法启动, selinux 为disabled
澳门美高梅官网
澳门美高梅官网
当前位置 : 澳门美高梅官网 > 澳门美高梅在线赌博

请教:CentOS 下 Mysql 无法启动, selinux 为disabled

错误信息为:

[root@server1 ~]# cat /usr/local/mysql/var/server1.err
160916 12:17:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
2016-09-16 12:17:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option see documentation for more details.
2016-09-16 12:17:12 0 [Note] /usr/sbin/mysqld mysqld 5.6.33-log starting as process 14526 ...
2016-09-16 12:17:12 14526 [Note] Plugin FEDERATED is disabled.
2016-09-16 12:17:12 14526 [Warning] The option innodb skip-innodb is deprecated and will be removed in a future release
2016-09-16 12:17:12 14526 [Note] Plugin InnoDB is disabled.
2016-09-16 12:17:12 14526 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-16 12:17:12 14526 [ERROR] Aborting

2016-09-16 12:17:12 14526 [Note] Binlog end
2016-09-16 12:17:12 14526 [Note] Shutting down plugin partition
2016-09-16 12:17:12 14526 [Note] Shutting down plugin PERFORMANCE_SCHEMA
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_SYS_DATAFILES
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_SYS_TABLESPACES
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_SYS_FOREIGN_COLS
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_SYS_FOREIGN
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_SYS_FIELDS
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_SYS_COLUMNS
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_SYS_INDEXES
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_SYS_TABLESTATS
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_SYS_TABLES
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_FT_INDEX_TABLE
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_FT_INDEX_CACHE
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_FT_CONFIG
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_FT_BEING_DELETED
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_FT_DELETED
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_FT_DEFAULT_STOPWORD
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_METRICS
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_BUFFER_POOL_STATS
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_BUFFER_PAGE_LRU
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_BUFFER_PAGE
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_CMP_PER_INDEX_RESET
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_CMP_PER_INDEX
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_CMPMEM_RESET
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_CMPMEM
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_CMP_RESET
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_CMP
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_LOCK_WAITS
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_LOCKS
2016-09-16 12:17:12 14526 [Note] Shutting down plugin INNODB_TRX
2016-09-16 12:17:12 14526 [Note] Shutting down plugin BLACKHOLE
2016-09-16 12:17:12 14526 [Note] Shutting down plugin ARCHIVE
2016-09-16 12:17:12 14526 [Note] Shutting down plugin MRG_MYISAM
2016-09-16 12:17:12 14526 [Note] Shutting down plugin MyISAM
2016-09-16 12:17:12 14526 [Note] Shutting down plugin MEMORY
2016-09-16 12:17:12 14526 [Note] Shutting down plugin CSV
2016-09-16 12:17:12 14526 [Note] Shutting down plugin sha256_password
2016-09-16 12:17:12 14526 [Note] Shutting down plugin mysql_old_password
2016-09-16 12:17:12 14526 [Note] Shutting down plugin mysql_native_password
2016-09-16 12:17:12 14526 [Note] Shutting down plugin binlog
2016-09-16 12:17:12 14526 [Note] /usr/sbin/mysqld: Shutdown complete

160916 12:17:12 mysqld_safe mysqld from pid file /usr/local/mysql/var/server1.pid ended

请教下这究竟是什么原因导致的?

错误信息显示是innodb引擎没启用。

关闭innodb

默认的存储引擎,my.ini中修改成MyISAM

default-storage-engine=MyISAM

然后尝试启动,如果启动OK,命令行连上mysql,然后安装innodb引擎

INSTALL PLUGIN InnoDB SONAME ha_innodb.so;

然后在my.ini修改回innodb,再重启应该就没问题了

广告位

澳门美高梅官网