处理请求时发生错误mysql procs,创建新用户时的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]: https://i.stack.imgur.com/PysWf.png

解决方案

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

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