打印

mysql无法启动

mysql无法启动

日记如下: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后无法启动

TOP

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

LNMP付费问题排查/LNMP技术支持/Paypal信用卡代付/代购VPS,域名,软件等 QQ 503228080 旺旺 lzhenbao
军哥淘宝店铺
QQ/旺旺仅提供代购及付费代维/问题解决等服务,其他不回复!LNMP相关问题请在本论坛发帖,提问前先搜索,按https://bbs.vpser.net/thread-2555-1-1.html 要求反馈问题!

TOP