WAMP服务器将MySQL切换到MariaDB [英] WAMP server switch MySQL to MariaDB

问题描述

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

How can I switch the database from MySQL to MariaDB in WAMP 3.1.0?

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

I'm looking for it, but I can not find it.

推荐答案

从您显示的图像来看，它似乎已经在运行MySQL和MariaDB！

From the image you show it looks like both MySQL and MariaDB are already running!

注意:那有点内存不足！

NOTE: Thats a bit memory hungry!

一个简单的测试，看看MySQL和MariaDB是否都在运行.启动phpMyAdmin并查看登录屏幕.如果两者都在运行，则应该在用户名"和密码"字段下看到一个服务器选择下拉列表.在该处，您将看到以下两个选项.

Simple test to see if both MySQL and MariaDB are running. Launch phpMyAdmin and look at the login screen. If both are running you should see a Server Choise dropdown under the Username and Password fields. In there you will see 2 options like below.

要选择MySQL或MariaDB，请右键单击系统托盘中wampmanager图标上的，您应该会看到此菜单

To pick MySQL or MariaDB, right click on the wampmanager icon in the system tray and you should see this this menu

只需单击MySQL或MariaDB即可启用或禁用任一或两个数据库服务器.如果数据库服务器名称旁边有一个绿色的勾号(如上面的MySQL所示)，则该数据库服务器被配置为运行，如果不存在该勾号，则该服务器未配置为运行.

Just click on either MySQL or MariaDB to Enable or Disable either or both database servers. If there is a green tick beside the database server name, like above against MySQL, then that database server is configured to run, and if no tick exists, that server is not configured to run.

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

Alternatively, just look at the services.msc snap-in to see if the database server is a) installed and b) running (started)

小注释 WAMPServer现在位于V3.1.2，可以在此处找到更新这包含一个修复程序，如果我没有记错的话，还包含一个相关的修复程序.这是WAMPServer备份存储库，但是它比SourceForge导航容易得多，并且通常比SourceForge更新，因为Oto不必跳过所有SourceForge循环即可保持最新.

Small note WAMPServer is now at V3.1.2, the update can be found here 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.

还请注意:MariaDB和MySQL不能同时在同一端口上运行，即3306.因此，默认情况下，MySQL在3306上运行，而MariaDB在3307上运行.当您编写PHP代码时，必须在数据库上指定端口3307.如果要同时运行两者，则可以使用连接代码来建立与MariaDB的连接.

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.

或者，如果只想使用MariaDB，请关闭MySQL，然后将MariaDB切换为使用端口3306.有些菜单项使查找它们变得非常容易.

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.

这篇关于WAMP服务器将MySQL切换到MariaDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！