创建新用户时的MySQL问题 [英] Mysql issue when creating a new user

问题描述

( 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

推荐答案

我也遇到了使用以下命令的错误: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

这篇关于创建新用户时的MySQL问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！