重启后数据库无法启动

goodboy

小白一个，日志如下，军哥帮助分析下：
2020-11-04 17:52:55 19752 [Note] Plugin 'FEDERATED' is disabled.
2020-11-04 17:52:55 19752 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-11-04 17:52:55 19752 [Note] InnoDB: The InnoDB memory heap is disabled
2020-11-04 17:52:55 19752 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-04 17:52:55 19752 [Note] InnoDB: Memory barrier is not used
2020-11-04 17:52:55 19752 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-04 17:52:55 19752 [Note] InnoDB: Using Linux native AIO
2020-11-04 17:52:55 19752 [Note] InnoDB: Using CPU crc32 instructions
2020-11-04 17:52:55 19752 [Note] InnoDB: Initializing buffer pool, size = 64.0M
2020-11-04 17:52:55 19752 [Note] InnoDB: Completed initialization of buffer pool
2020-11-04 17:52:55 19752 [Note] InnoDB: Highest supported file format is Barracuda.
2020-11-04 17:52:55 19752 [Note] InnoDB: 128 rollback segment(s) are active.
2020-11-04 17:52:55 19752 [Note] InnoDB: Waiting for purge to start
2020-11-04 17:52:55 19752 [Note] InnoDB: 5.6.49 started; log sequence number 1626084
2020-11-04 17:52:55 19752 [Note] Recovering after a crash using mysql-bin
2020-11-04 17:52:55 19752 [Note] Starting crash recovery...
2020-11-04 17:52:55 19752 [Note] Crash recovery finished.
2020-11-04 17:52:55 19752 [Note] RSA private key file not found: /usr/local/mysql/var//private_key.pem. Some authentication plugins will not work.
2020-11-04 17:52:55 19752 [Note] RSA public key file not found: /usr/local/mysql/var//public_key.pem. Some authentication plugins will not work.
2020-11-04 17:52:55 19752 [Note] Server hostname (bind-address): '*'; port: 3306
2020-11-04 17:52:55 19752 [Note] IPv6 is available.
2020-11-04 17:52:55 19752 [Note]   - '::' resolves to '::';
2020-11-04 17:52:55 19752 [Note] Server socket created on IP: '::'.
2020-11-04 17:52:55 19752 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it

licess

mysql配置文件你做过什么变动？顺便贴mysql配置文件看一下

goodboy

没变动，从5.4升级到5.6

goodboy

1. [client]
   
2. #password   = your_password
   
3. port        = 3306
   
4. socket      = /tmp/mysql.sock
   
5. 
   
6. [mysqld]
   
7. port        = 3306
   
8. socket      = /tmp/mysql.sock
   
9. datadir = /usr/local/mysql/var
   
10. skip-external-locking
    
11. key_buffer_size = 16M
    
12. max_allowed_packet = 1M
    
13. table_open_cache = 64
    
14. sort_buffer_size = 512K
    
15. net_buffer_length = 8K
    
16. read_buffer_size = 256K
    
17. read_rnd_buffer_size = 512K
    
18. myisam_sort_buffer_size = 8M
    
19. thread_cache_size = 8
    
20. query_cache_size = 8M
    
21. tmp_table_size = 16M
    
22. performance_schema_max_table_instances = 500
    
23. 
    
24. explicit_defaults_for_timestamp = true
    
25. #skip-networking
    
26. max_connections = 500
    
27. max_connect_errors = 100
    
28. open_files_limit = 65535
    
29. 
    
30. log-bin=mysql-bin
    
31. binlog_format=mixed
    
32. server-id   = 1
    
33. expire_logs_days = 10
    
34. 
    
35. #loose-innodb-trx=0
    
36. #loose-innodb-locks=0
    
37. #loose-innodb-lock-waits=0
    
38. #loose-innodb-cmp=0
    
39. #loose-innodb-cmp-per-index=0
    
40. #loose-innodb-cmp-per-index-reset=0
    
41. #loose-innodb-cmp-reset=0
    
42. #loose-innodb-cmpmem=0
    
43. #loose-innodb-cmpmem-reset=0
    
44. #loose-innodb-buffer-page=0
    
45. #loose-innodb-buffer-page-lru=0
    
46. #loose-innodb-buffer-pool-stats=0
    
47. #loose-innodb-metrics=0
    
48. #loose-innodb-ft-default-stopword=0
    
49. #loose-innodb-ft-inserted=0
    
50. #loose-innodb-ft-deleted=0
    
51. #loose-innodb-ft-being-deleted=0
    
52. #loose-innodb-ft-config=0
    
53. #loose-innodb-ft-index-cache=0
    
54. #loose-innodb-ft-index-table=0
    
55. #loose-innodb-sys-tables=0
    
56. #loose-innodb-sys-tablestats=0
    
57. #loose-innodb-sys-indexes=0
    
58. #loose-innodb-sys-columns=0
    
59. #loose-innodb-sys-fields=0
    
60. #loose-innodb-sys-foreign=0
    
61. #loose-innodb-sys-foreign-cols=0
    
62. 
    
63. default_storage_engine = InnoDB
    
64. innodb_data_home_dir = /usr/local/mysql/var
    
65. innodb_data_file_path = ibdata1:10M:autoextend
    
66. innodb_log_group_home_dir = /usr/local/mysql/var
    
67. innodb_buffer_pool_size = 64M
    
68. innodb_log_file_size = 5M
    
69. innodb_log_buffer_size = 8M
    
70. innodb_flush_log_at_trx_commit = 1
    
71. innodb_lock_wait_timeout = 50
    
72. 
    
73. [mysqldump]
    
74. quick
    
75. max_allowed_packet = 16M
    
76. 
    
77. [mysql]
    
78. no-auto-rehash
    
79. 
    
80. [myisamchk]
    
81. key_buffer_size = 20M
    
82. sort_buffer_size = 20M
    
83. read_buffer = 2M
    
84. write_buffer = 2M
    
85. 
    
86. [mysqlhotcopy]
    
87. interactive-timeout
    
88. 
    

复制代码

goodboy

谢谢军哥，小白真的不知道怎么解决？麻烦军哥

licess

提供升级日志看下
先备份数据库目录，然后执行命令：
/usr/local/mysql/bin/mysqld_safe --skip-grant-tables &
mysql
repair table  mysql.user;
然后看看返回信息是否报错
kill `pidof mysqld`
再启动mysql看一下

goodboy

按照军哥说的已经解决，谢谢