创建新用户时的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
lokeven 回答:创建新用户时的MySQL问题

我也遇到了

“错误:mysqlcheck不支持多个矛盾的命令”

使用以下命令发布

-DarchetypeRepository

我所做的事情(因为我懒惰而已)是分别运行所有内容并使用> mvn archetype:generate -DarchetypeGroupId=org.sakaiproject.maven-archetype -DarchetypeArtifactId=sakai-spring-maven-archetype -DarchetypeVersion=1.2 -DarchetypeRepository=https://source.sakaiproject.org/maven2 [INFO] Scanning for projects... [INFO] [INFO] ------------------< org.apache.maven:standalone-pom >------------------- [INFO] Building Maven Stub Project (No POM) 1 [INFO] --------------------------------[ pom ]--------------------------------- [INFO] [INFO] >>> maven-archetype-plugin:3.1.2:generate (default-cli) > generate-sources @ standalone-pom >>> [INFO] [INFO] <<< maven-archetype-plugin:3.1.2:generate (default-cli) < generate-sources @ standalone-pom <<< [INFO] [INFO] [INFO] --- maven-archetype-plugin:3.1.2:generate (default-cli) @ standalone-pom --- [INFO] Generating project in Interactive mode [WARNING] Archetype not found in any catalog. Falling back to central repository. [WARNING] Add a repository with id 'archetype' in your settings.xml if archetype's repository is elsewhere. [WARNING] The POM for org.sakaiproject.maven-archetype:sakai-spring-maven-archetype:jar:1.2 is missing,no dependency information available [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 4.395 s [INFO] Finished at: 2020-01-11T12:24:20+01:00 [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.apache.maven.plugins:maven-archetype-plugin:3.1.2:generate (default-cli) on project standalone-pom: The desired archetype does not exist (org.sakaiproject.maven-archetype:sakai-spring-maven-archetype:1.2) -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors,re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions,please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException 而不是mysqlcheck -u root -p --auto-repair -c -o --all-databases

进行修复的。
-r
,

真的不知道问题的起因是否相同,但我使用mysqlcheck解决了此问题。运行

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

在终端中(运行此命令后,如果已设置,将提示您输入root密码)。

运行此命令并浏览输出,我发现问题出在tables_priv数据库中的mysql表中。因此,我使用了-r的{​​{1}}标志对其进行了修复。

mysqlcheck

(再次提示输入密码,然后输入)。这样就解决了。真的不知道问题的原因,但是希望这可以帮助遇到相同问题的其他人。

您也可以运行

mysqlcheck -r mysql tables_priv -u root -p

自动修复所有损坏的表而无需查找损坏的表(不知道这是否会对您的其他任何表产生负面影响,因此请尝试第一种方法,如果失败,请尝试此方法)。

您可以从here获得有关mysqlcheck -u root -p --auto-repair -c -o --all-databases 的更多信息

本文链接:https://www.f2er.com/3138285.html

大家都在问