VPS侦探论坛

 找回密码
 注册
查看: 424|回复: 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后无法启动
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org/
发表于 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;
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org/
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2019-8-22 16:24 , Processed in 0.071172 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

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