VPS侦探论坛

 找回密码
 注册
搜索
热搜: pathinfo
查看: 296|回复: 1

mysql无法启动

[复制链接]
发表于 2019-1-13 20:26:08 | 显示全部楼层 |阅读模式



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

美国VPS、VPN、域名代购:http://shop63846532.taobao.com/

发表于 2019-1-14 14:49:45 | 显示全部楼层


数据库表损坏了,修复一下试试
/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;
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2019-4-25 19:10 , Processed in 0.042221 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表