背景:首先,我们已经从MySQL 5.6升级到MySQL 8.0.12(5.6-->;5.7-->;8.0.12),并且运行良好.
现在,我们正在try 从8.0.12升级到8.0.32,并通过了此链接中提到的所有初步判断(Prerequisites).
已通过将8.0.12二进制文件替换为8.0.32进行升级,并try 启动服务器.但得到与其中一个数据字典表的datetime
值有关的以下错误.
我看到了许多与此错误类似的问题,但这些错误与用户表有关.为此,我做了一个与升级过程相关的标题.
2023-02-28T13:28:00.305202Z 0 \[System\] \[MY-010116\] \[Server\] C:\\Program Files\\MySQL\\MySQL Server 5.6\\bin\\mysqld (mysqld 8.0.32) starting as process 13296
2023-02-28T13:28:00.326722Z 1 \[System\] \[MY-013576\] \[InnoDB\] InnoDB initialization has started.
2023-02-28T13:28:01.109930Z 1 \[System\] \[MY-013577\] \[InnoDB\] InnoDB initialization has ended.
2023-02-28T13:28:01.139462Z 1 [System] [MY-011090] [Server] Data dictionary upgrading from version '80012' to '80023'.
2023-02-28T13:28:07.931896Z 1 \[ERROR\] \[MY-013178\] \[Server\] Execution of server-side SQL statement 'INSERT INTO st_spatial_reference_systems SELECT \* FROM mysql.st_spatial_reference_systems' failed with error code = 1292, error message = 'Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_altered' at row 2'.
2023-02-28T13:28:09.524427Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-02-28T13:28:09.524886Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-28T13:28:11.167707Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
我已经try 访问该数据字典表mysql.st_spatial_reference_systems
,但是访问被拒绝.
有什么方法可以更改该列默认值吗?请提个建议.