创建新用户时的MySQL问题

本文介绍了创建新用户时的MySQL问题的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 ( SELECT DISTINCT User , Host FROM mysql.user ) UNION ( SELECT DISTINCT User , Host FROM mysql.db ) UNION ( SELECT DISTINCT User , Host FROM mysql.tables_priv ) UNION ( SELECT DISTINCT User , Host FROM mysql.columns_priv ) UNION ( SELECT DISTINCT User , Host FROM mysql.procs_priv ) ORDER BY User ASC , Host ASC

Mysql said: `#1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria` [Error here][1] [1]: i.stack.imgur/PysWf.png

推荐答案

我也遇到了使用以下命令的错误:mysqlcheck不支持多个矛盾的命令"问题

I too ran into the "Error: mysqlcheck doesn't support multiple contradicting commands" issue using the following command

mysqlcheck -u root -p --auto-repair -c -o --all-databases

我所做的事情以及由于我懒惰而造成的后果，分别运行了所有内容，并使用-r进行了修复，而不是使用--auto-repair

What I did, and its because I am lazy lol, was run everything separately and used the -r for repair instead of --auto-repair

mysqlcheck -u root -p -r --all-databases mysqlcheck -u root -p -c --all-databases mysqlcheck -u root -p -o --all-databases