创建新用户时的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


我也遇到了

“错误：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] -------------------------------------
[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] <<[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
的更多信息