无法在update_mysql 5.5中运行MySQL

Question

我最近接管了管理运行在Windows 2008 R2上的R2数据库的工作。它正在运行5.5.37 Community。启动时，它包括以下几行：

Thread, Type, Details
Column count of mysql.events_waits_current is wrong. Expected 16, found 19. The table is probably corrupted
Column count of mysql.events_waits_history is wrong. Expected 16, found 19. The table is probably corrupted
Column count of mysql.events_waits_history_long is wrong. Expected 16, found 19. The table is probably corrupted
Native table 'performance_schema'.'threads' has the wrong structure
Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
Column count of mysql.file_summary_by_event_name is wrong. Expected 5, found 23. The table is probably corrupted
Column count of mysql.file_summary_by_instance is wrong. Expected 6, found 25. The table is probably corrupted
Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type int(11), found type bigint(20) unsigned.
Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type int(11), found type bigint(20) unsigned.

我试着运行mysql_upgrade，但是得到了以下结果：

Looking for 'mysql.exe' as: C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqlcheck.exe
The system cannot find the file specified.
FATAL ERROR: Upgrade failed

路径指向正确的位置。我可以从这些地方运行mysql.exe和mysqlcheck.exe。我正在从管理员级命令提示符运行。

我尝试过使用参数mysqlcheck.exe运行--all-databases，所有检查结果都是OK的。但是，当我重新启动MySQL时，这些错误仍然存在。

有什么办法可以消除这些错误吗？

Answer 1

正如您所提到的，您正在绑定运行mysql_upgrade，它正在查找'mysql.exe‘和'mysqlcheck.exe’。

为了更容易地调用MySQL程序，可以将MySQL bin目录的路径名添加到Windows环境变量中：

下面是在Windows路径中设置Mysql环境变量的链接。

希望这能帮到你。