加入收藏 | 设为首页 | 会员中心 | 我要投稿 核心网 (https://www.hxwgxz.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 编程 > 正文

WAMP服务器将MySQL切换到MariaDB

发布时间:2021-03-31 05:17:09 所属栏目:编程 来源:网络整理
导读:如何在WAMP 3.1.0中将数据库从MySQL切换到MariaDB? 我正在寻找它,但我找不到它. 最佳答案从您显示的图像看起来MySQL和MariaDB都已经运行了! 注意:这有点内存饥饿! 简单测试以查看MySQL和MariaDB是否都在运行.启动phpMyAdmin并查看登录屏幕.如果两者都在

如何在WAMP 3.1.0中将数据库从MySQL切换到MariaDB?

我正在寻找它,但我找不到它.

最佳答案 从您显示的图像看起来MySQL和MariaDB都已经运行了!

注意:这有点内存饥饿!

简单测试以查看MySQL和MariaDB是否都在运行.启动phpMyAdmin并查看登录屏幕.如果两者都在运行,您应该在“用户名”和“密码”字段下看到“服务器选择”下拉列表.在那里你会看到2个选项,如下所示.

要选择MySQL或MariaDB,请右键单击系统托盘中的wampmanager图标,您将看到此菜单

只需单击MySQL或MariaDB即可启用或禁用其中一个或两个数据库服务器.如果数据库服务器名称旁边有一个绿色勾号,如上面针对MySQL,则该数据库服务器配置为运行,如果不存在勾选,则该服务器未配置为运行.

或者,只需查看services.msc管理单元以查看数据库服务器是否已安装并且b)正在运行(已启动)

Small note WAMPServer is now at V3.1.2,07002 This contains a fix that if I remember correctly,contains a relevant fix. This is the WAMPServer backup repo,but it is a lot easier to navigate than SourceForge and is often more up to date than SourceForge as Oto does not have to jump through all the SourceForge loops to keep it up to date.

Also note: that MariaDB and MySQL cannot both run on the same port i.e. 3306. So by default MySQL runs on 3306 and MariaDB runs on 3307. When you come to write PHP code you will have to specify port 3307 on your database connection code to make the connection to MariaDB if you are going to run both at the same time.

Alternatively,if you want to use just MariaDB,Turn off MySQL and then switch MariaDB to use port 3306. There are menu items that make it quite easy if you look for them.

(编辑:核心网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    热点阅读