MySQL8.0 user表被删除了怎么办

Question

MySQL8.0 user表被删除了 操作不了mysql数据库了 怎么恢复系统user表

Answer 1

使用binlog日志进行数据恢复，参考：https://blog.csdn.net/Allenzyg/article/details/106446992?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522168133136216800188552865%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=168133136216800188552865&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_ecpm_v1~rank_v31_ecpm-2-106446992-null-null.blog_rank_default&utm_term=binlog&spm=1018.2226.3001.4450