升级了mysql 5.618 出现这个错误怎么办？
lnmp1.2151211 11:16:02 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
2015-12-11 11:16:02 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-11 11:16:02 0 /usr/local/mysql/bin/mysqld (mysqld 5.6.28-log) starting as process 4584 ...
2015-12-11 11:16:02 4584 ignore-builtin-innodb is ignored and will be removed in future releases.
2015-12-11 11:16:02 4584 The option innodb (skip-innodb) is deprecated and will be removed in a future release
2015-12-11 11:16:02 4584 The option innodb (skip-innodb) is deprecated and will be removed in a future release
2015-12-11 11:16:02 4584 Using unique option prefix innodb-locks instead of innodb-locks-unsafe-for-binlog is deprecated and will be removed in a future release. Please use the full name instead.
2015-12-11 11:16:02 4584 Using unique option prefix innodb-cmp instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2015-12-11 11:16:02 4584 Using unique option prefix innodb-cmp-per-index instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2015-12-11 11:16:02 4584 Plugin 'InnoDB' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_TRX' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_LOCK_WAITS' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_CMP_RESET' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_CMPMEM' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_CMPMEM_RESET' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_BUFFER_PAGE' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_METRICS' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_FT_DELETED' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_FT_CONFIG' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_SYS_TABLES' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_SYS_INDEXES' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_SYS_COLUMNS' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_SYS_FIELDS' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_SYS_FOREIGN' is disabled.
2015-12-11 11:16:02 4584 Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
2015-12-11 11:16:02 4584 Plugin 'FEDERATED' is disabled.
2015-12-11 11:16:02 4584 /usr/local/mysql/bin/mysqld: unknown variable 'loose-innodb-ft-inserted=0'
/usr/local/mysql/bin/mysqld: File './mysql-bin.000006' not found (Errcode: 2 - No such file or directory)
2015-12-11 11:16:02 4584 Failed to open log (file './mysql-bin.000006', errno 2)
2015-12-11 11:16:02 4584 Could not open log file
2015-12-11 11:16:02 4584 Can't init tc log
2015-12-11 11:16:02 4584 Aborting
2015-12-11 11:16:02 4584 Binlog end
2015-12-11 11:16:02 4584 Shutting down plugin 'partition'
2015-12-11 11:16:02 4584 Shutting down plugin 'BLACKHOLE'
2015-12-11 11:16:02 4584 Shutting down plugin 'ARCHIVE'
2015-12-11 11:16:02 4584 Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-12-11 11:16:02 4584 Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-12-11 11:16:02 4584 Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-12-11 11:16:02 4584 Shutting down plugin 'INNODB_CMP'
2015-12-11 11:16:02 4584 Shutting down plugin 'INNODB_LOCKS'
2015-12-11 11:16:02 4584 Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-12-11 11:16:02 4584 Shutting down plugin 'MRG_MYISAM'
2015-12-11 11:16:02 4584 Shutting down plugin 'CSV'
2015-12-11 11:16:02 4584 Shutting down plugin 'MyISAM'
2015-12-11 11:16:02 4584 Shutting down plugin 'MEMORY'
2015-12-11 11:16:02 4584 Shutting down plugin 'sha256_password'
2015-12-11 11:16:02 4584 Shutting down plugin 'mysql_old_password'
2015-12-11 11:16:02 4584 Shutting down plugin 'mysql_native_password'
2015-12-11 11:16:02 4584 Shutting down plugin 'binlog'
2015-12-11 11:16:02 4584 /usr/local/mysql/bin/mysqld: Shutdown complete
151211 11:16:02 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY131013141355585524Z.pid ended 2015-12-11 11:16:02 4584 Failed to open log (file './mysql-bin.000006', errno 2)
2015-12-11 11:16:02 4584 Could not open log file
2015-12-11 11:16:02 4584 Can't init tc log
2015-12-11 11:16:02 4584 Aborting
ls -l /usr/local/mysql/var/
先查看一下数据库目录下mysql-bin.000之类的权限，属主和属组是否是mysql
如果不是 chown mysql:mysql -R /usr/local/mysql/var/
如果还不行可以清空mysql-bin.index文件，删除mysql-bin.000这些文件
页:
[1]