mysql无法启动
日记如下：2019-01-13 19:59:12 14049 Plugin 'FEDERATED' is disabled.2019-01-13 19:59:12 14049 InnoDB: Using atomics to ref count buffer pool pages
2019-01-13 19:59:12 14049 InnoDB: The InnoDB memory heap is disabled
2019-01-13 19:59:12 14049 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-13 19:59:12 14049 InnoDB: Memory barrier is not used
2019-01-13 19:59:12 14049 InnoDB: Compressed tables use zlib 1.2.11
2019-01-13 19:59:12 14049 InnoDB: Using Linux native AIO
2019-01-13 19:59:12 14049 InnoDB: Using CPU crc32 instructions
2019-01-13 19:59:12 14049 InnoDB: Initializing buffer pool, size = 16.0M
2019-01-13 19:59:12 14049 InnoDB: Completed initialization of buffer pool
2019-01-13 19:59:12 14049 InnoDB: Highest supported file format is Barracuda.
2019-01-13 19:59:12 14049 InnoDB: 128 rollback segment(s) are active.
2019-01-13 19:59:12 14049 InnoDB: Waiting for purge to start
2019-01-13 19:59:12 14049 InnoDB: 5.6.42 started; log sequence number 1626044
2019-01-13 19:59:12 14049 Recovering after a crash using mysql-bin
2019-01-13 19:59:12 14049 Starting crash recovery...
2019-01-13 19:59:12 14049 Crash recovery finished.
2019-01-13 19:59:12 14049 Server hostname (bind-address): '*'; port: 3306
2019-01-13 19:59:12 14049 IPv6 is available.
2019-01-13 19:59:12 14049 - '::' resolves to '::';
2019-01-13 19:59:12 14049 Server socket created on IP: '::'.
2019-01-13 19:59:12 14049 Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it
用的是linode centos7,升级mysql5.6.42后无法启动 数据库表损坏了，修复一下试试
/etc/init.d/mysql stop
pkill -9 mysqld
/usr/local/mysql/bin/mysqld_safe --user=root --skip-grant-tables
mysql -uroot -p
repair table mysql.user USE_FRM;
页:
[1]