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

问题.

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文件请删除

然后执行安装就成了

相关推荐

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

    2024-03-31 14:16:08       40 阅读
  2. MySQL商城数据表(80-88

    2024-03-31 14:16:08       33 阅读
  3. MySQL商城数据表(80-84

    2024-03-31 14:16:08       32 阅读
  4. 安装mysql-8.0.19-winx64.zip步骤

    2024-03-31 14:16:08       30 阅读
  5. 关于Qt的安装版本更换

    2024-03-31 14:16:08       45 阅读

最近更新

  1. docker php8.1+nginx base 镜像 dockerfile 配置

    2024-03-31 14:16:08       98 阅读
  2. Could not load dynamic library ‘cudart64_100.dll‘

    2024-03-31 14:16:08       106 阅读
  3. 在Django里面运行非项目文件

    2024-03-31 14:16:08       87 阅读
  4. Python语言-面向对象

    2024-03-31 14:16:08       96 阅读

热门阅读

  1. cephadm安装reef版本ceph集群

    2024-03-31 14:16:08       40 阅读
  2. PyTorch-----torch.flatten()函数

    2024-03-31 14:16:08       35 阅读
  3. js关于字符串的方法

    2024-03-31 14:16:08       41 阅读
  4. 2024年保安员职业资格考试真题题库

    2024-03-31 14:16:08       39 阅读
  5. 5.FileChannel

    2024-03-31 14:16:08       28 阅读
  6. ospf配置静态路由实验

    2024-03-31 14:16:08       40 阅读
  7. 数据结构--合并区间

    2024-03-31 14:16:08       37 阅读