mysql无法启动

dragonrabbit

日记如下：2019-01-13 19:59:12 14049 [Note] Plugin 'FEDERATED' is disabled.
2019-01-13 19:59:12 14049 [Note] InnoDB: Using atomics to ref count buffer pool pages
2019-01-13 19:59:12 14049 [Note] InnoDB: The InnoDB memory heap is disabled
2019-01-13 19:59:12 14049 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-13 19:59:12 14049 [Note] InnoDB: Memory barrier is not used
2019-01-13 19:59:12 14049 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-01-13 19:59:12 14049 [Note] InnoDB: Using Linux native AIO
2019-01-13 19:59:12 14049 [Note] InnoDB: Using CPU crc32 instructions
2019-01-13 19:59:12 14049 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-01-13 19:59:12 14049 [Note] InnoDB: Completed initialization of buffer pool
2019-01-13 19:59:12 14049 [Note] InnoDB: Highest supported file format is Barracuda.
2019-01-13 19:59:12 14049 [Note] InnoDB: 128 rollback segment(s) are active.
2019-01-13 19:59:12 14049 [Note] InnoDB: Waiting for purge to start
2019-01-13 19:59:12 14049 [Note] InnoDB: 5.6.42 started; log sequence number 1626044
2019-01-13 19:59:12 14049 [Note] Recovering after a crash using mysql-bin
2019-01-13 19:59:12 14049 [Note] Starting crash recovery...
2019-01-13 19:59:12 14049 [Note] Crash recovery finished.
2019-01-13 19:59:12 14049 [Note] Server hostname (bind-address): '*'; port: 3306
2019-01-13 19:59:12 14049 [Note] IPv6 is available.
2019-01-13 19:59:12 14049 [Note]   - '::' resolves to '::';
2019-01-13 19:59:12 14049 [Note] Server socket created on IP: '::'.
2019-01-13 19:59:12 14049 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it


用的是linode centos7,升级mysql5.6.42后无法启动

licess

数据库表损坏了，修复一下试试
/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;