将Wamp Server升级到MySQL 8.0.15 [英] Upgrading Wamp Server to MySQL 8.0.15

问题描述

所以几个月前我最近安装了WampServer，并预安装了mySQL 5.7。

So I recently installed the WampServer a few months back, with a pre-installed mySQL 5.7.

但是我想利用NoSQL附带的功能mySQL 8。

But I wanted to take advantage of the NoSQL features that come with mySQL 8.

要进行更新，我下载了最新的MySQL版本，将该文件夹提取到wamp64的bin目录中。然后，我从5.7文件夹中复制了wampserver.conf和my.ini文件，并将其粘贴到8目录中。

To update it, I downloaded the latest MySQL version, extracted the folder to the bin directory of wamp64. I then copied the wampserver.conf and my.ini files from the 5.7 folder and pasted it in to the 8 directory.

我在cmd行中运行以下提示： mysqld.exe-初始化不安全

I ran on the cmd line the following prompt: mysqld.exe --initialize-insecure

然后我编辑了my.ini文件，并将每个实例5.7更改为8.0。

I then edited the my.ini file and changed every instance of 5.7 to 8.0.

但是现在当我运行wamp时，MySQL无法启动，并且出现此错误：
错误

But now when I run wamp MySQL doesnt start and I get this error: error

有人知道我做错了什么或如何解决吗？

Does anyone know what I did wrong or how I can fix this?

推荐答案

我在 http：// forum.wampserver.com/read.php?2,147674,147689 ，它对我有用。

• 退出Wampserver


• 下载MySQL版本并将其解压缩到一个文件夹，例如mysql-8.0.2-dmr-winx64


• 将文件夹的内容复制到新的mysql子目录中，例如wamp64 / bin / mysql / mysql8.0.2


• 在wamp64 / bin / mysql / mysql8.0.2 / bin /
中打开命令窗口（以管理员身份）

• 类型：mysqld.exe-初始化不安全
  ---这将创建正确的数据文件夹


• 将wampserver.conf从mysql5.7.14复制到mysql8.0.2


• 将my.ini从mysql5.7.14复制到mysql8.0.2


• 编辑mysql8.0.2 / my.ini并替换所有mysql5.7.14实例使用mysql8.0.2（然后保存）


• 以管理员身份运行WampServer64

• Exit Wampserver
• Download MySQL version and extract to a folder, e.g. mysql-8.0.2-dmr-winx64
• Copy the contents of the folder to a new mysql subdirectory, e.g. wamp64/bin/mysql/mysql8.0.2
• Open a command windows (as an administrator) on wamp64/bin/mysql/mysql8.0.2/bin/
• Type : mysqld.exe --initialize-insecure --- This will create the right data folder
• Copy wampserver.conf from mysql5.7.14 to mysql8.0.2
• Copy my.ini from mysql5.7.14 to mysql8.0.2
• Edit mysql8.0.2/my.ini and replace all instances of mysql5.7.14 with mysql8.0.2 (then save)
• Run WampServer64 as administrator

这篇关于将Wamp Server升级到MySQL 8.0.15的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！