补关于zip安装mysql-8.0版本问题

文章讲述了在尝试重新安装MySQL8.0.28时遇到的问题,涉及character-set-server设置的升级建议(从UTF8变为UTF8MB4),以及因原有data目录残留文件导致的安装失败,解决方案是更新my.ini并清理数据文件。
摘要由CSDN通过智能技术生成

问题.

2024-03-30T07:42:07.863484Z 0 [System] [MY-013169] [Server] D:\develop\mysql\mysql-8.0.28-winx64\bin\mysqld.exe (mysqld 8.0.28) initializing of server in progress as process 28464 2024-03-30T07:42:07.864206Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2024-03-30T07:42:07.864797Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2024-03-30T07:42:07.864803Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\develop\mysql\mysql-8.0.28-winx64\data\ is unusable. You can remove all files that the server added to it. 2024-03-30T07:42:07.865132Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-03-30T07:42:07.865669Z 0 [System] [MY-010910] [Server] D:\develop\mysql\mysql-8.0.28-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.28) MySQL Community Server - GPL.

突发奇想想重装下mysql,然后按照之前文章记录安装出现上述问题

根据问题描述:

1.my.ini文件中  character-set-server 应改为UTF8MB4

2.原始记录文件夹中有配置的data文件请删除

解决:

my.ini文件中  character-set-server = UTF8MB4

原始记录文件夹中有配置的data文件请删除

然后执行安装就成了

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值