已经安装了apache和mysql的XAMPP

is there any problem to install xampp with apache and mysql already installed?

安装xampp与apache和mysql已经安装有什么问题吗？

9 个解决方案

#1

There shouldn't be any problem. Just know that you won't be able to start both Apache servers or by MySQL servers at the same time without modifying them to use non-standard ports. (You could easily use the XAMPP MySQL server with your existing Apache or your existing MySQL server with the XAMPP Apache.)

应该没有任何问题。要知道，如果不修改它们以使用非标准端口，您将无法同时启动Apache服务器或MySQL服务器。 （您可以轻松地将XAMPP MySQL服务器与现有Apache或现有MySQL服务器与XAMPP Apache一起使用。）

You may also have some problems with registering the XAMPP Apache and MySQL as Windows services using the XAMPP controls if you have your other Apache and MySQL servers configured as services (I'm expecting service name conflicts).

如果您将其他Apache和MySQL服务器配置为服务（我预计服务名称冲突），您可能会在使用XAMPP控件将XAMPP Apache和MySQL注册为Windows服务时遇到一些问题。

If you already have Apache and MySQL installed on your machine, I'm not sure why you would want to also install XAMPP.

如果您的计算机上已经安装了Apache和MySQL，我不确定您为什么还要安装XAMPP。

#2

For personal use? Works fine! Just use the right applications (xampp_start/xampp_stop) to run apache/mysql server!

供个人使用？工作正常！只需使用正确的应用程序（xampp_start / xampp_stop）来运行apache / mysql服务器！

#3

The best way is to change the port number from 3306 to 3307 for the pre-existing MySQL server so you can use both MySQL instances (XAMPP MySQL and pre-existing MySQL) simultaneously without conflict.

对于预先存在的MySQL服务器，最好的方法是将端口号从3306更改为3307，这样您就可以同时使用两个MySQL实例（XAMPP MySQL和预先存在的MySQL）而不会发生冲突。

#4

I think you might want to consider removing apache and mysql and installing xampp after. Xampp will add both and they might collide if you install xampp and they are already installed. You should do a backup on your mysql databases and put them back after and you should be fine.

我想你可能想考虑删除apache和mysql并在之后安装xampp。 Xampp将添加两者，如果您安装xampp并且它们已经安装，它们可能会发生冲突。你应该在你的mysql数据库上做一个备份并把它们放回去，你应该没问题。

#5

You need to change the port number in MySQL installer, you will find an option to reconfigure MySQL server.

您需要在MySQL安装程序中更改端口号，您将找到重新配置MySQL服务器的选项。

Change its port number to 3308 and everything will work fine then.

将其端口号更改为3308，然后一切正常。

#6

There should be no problem, but you need to decide which MySQL server you will use, whether the installed one along XAMPP or the exist MySQL server

应该没有问题，但您需要决定使用哪个MySQL服务器，是否沿着XAMPP安装了MySQL服务器或存在MySQL服务器

#7

If you have Apache and MySQL already installed then why do you need XAMPP? Surely you already have the full LAMP / WAMP stack already?

如果您已安装Apache和MySQL，那么为什么需要XAMPP？你肯定已经拥有完整的LAMP / WAMP堆栈吗？

Just to add a note.

只是添加一个注释。

I had previously installed MySQL server on my local machine for some development projects that didn't require an ..AMP stack. Mainly NodeJS, Angular and Java applications.

我以前在本地机器上安装了MySQL服务器，用于一些不需要.AMP堆栈的开发项目。主要是NodeJS，Angular和Java应用程序。

Most of my web development was done on an ubuntu server running a LAMP stack, so I never bothered to set up a local development environment for web development.

我的大部分Web开发都是在运行LAMP堆栈的ubuntu服务器上完成的，所以我从不打算为Web开发设置本地开发环境。

In the last couple of days I decided to setup a development environment on my Windows 10 machine using XAMPP (with a MySQL server already running). Here is what I found:

在过去的几天里，我决定使用XAMPP在我的Windows 10机器上设置开发环境（已经运行了MySQL服务器）。这是我发现的：

Running projects that connect to the local MySQL server is not an issue since all the database connections are written in each individual project. So really, installing MySQL with XAMPP is not a requirement at all. You can definitely live without it being part of the XAMPP install.

运行连接到本地MySQL服务器的项目不是问题，因为所有数据库连接都写在每个单独的项目中。实际上，使用XAMPP安装MySQL根本不是必需的。如果没有它成为XAMPP安装的一部分，你绝对可以活下去。

What I did want was the phpmyadmin console for administering the existing MySQL server. So, I did some digging through the xampp directories.

我想要的是用于管理现有MySQL服务器的phpmyadmin控制台。所以，我做了一些挖掘xampp目录。

You can add the username and password of the local MySQL database server in this file:

您可以在此文件中添加本地MySQL数据库服务器的用户名和密码：

/xampp/phpMyAdmin/config.inc.php

/xampp/phpMyAdmin/config.inc.php

phpMyAdmin will now be accessible via http://localhost/phpmyadmin and will be connected to the existing MySQL installation.

phpMyAdmin现在可以通过http：// localhost / phpmyadmin访问，并将连接到现有的MySQL安装。

You will also need to create a phpmyadmin database on the local MySQL server to store the phpmyadmin settings, plus a 'pma'@'localhost' account with no password. Logging into phpyadmin will prompt you for creating the database, just follow the prompts and phpmyadmin will handle the database creation. The pma (PhpMyAdmin) user will have to be created manually, no password, with full admin permissions. Now you are good to go...

您还需要在本地MySQL服务器上创建一个phpmyadmin数据库来存储phpmyadmin设置，以及一个没有密码的'pma'@'localhost'帐户。登录phpyadmin将提示您创建数据库，只需按照提示操作，phpmyadmin将处理数据库创建。必须手动创建pma（PhpMyAdmin）用户，没有密码，具有完全管理员权限。现在你很高兴去...

I tried my best to link the MySQL server to the XAMPP admin console but struggled to get the XAMPP admin console to recognise that the MySQL server was enabled. I tried editing the path to the mysqld.exe and my-default.ini files in several of the XAMPP files but none made a difference. I would love to know if this is possible.

我尽力将MySQL服务器链接到XAMPP管理控制台，但很难让XAMPP管理控制台认识到MySQL服务器已启用。我尝试在几个XAMPP文件中编辑mysqld.exe和my-default.ini文件的路径，但没有任何区别。我很想知道这是否可行。

Files I edited:

我编辑过的文件：

• uMain.pas
• uMain.pas
• xampp_shell.bat
• xampp_shell.bat
• MySQL_start.bat
• MySQL_start.bat
• xampp_start.c
• xampp_start.c
• ctl.bat
• ctl.bat

Unfortunately none of the edits made a difference. However, I was still able to admin the MySQL server from phpmyadmin and MySQL Workbench so no loss really.

不幸的是，没有一个编辑产生了影响。但是，我仍然可以从phpmyadmin和MySQL Workbench管理MySQL服务器，所以没有真正的损失。

Hope that helps someone :)

希望有人帮助:)

#8

It really easy ...Just u have to stop apache and mysql services manually ..no need to modify any port no.

它真的很容易......只需你手动停止apache和mysql服务..不需要修改任何端口号。

After that u can start the apache and mysql service through Xammp :)

之后你可以通过Xammp启动apache和mysql服务:)

#9

The simplest answer to this problem is to install the Xampp server without selecting the MySQL at the time of installation if you already have an existing MySQL server running.

如果您已经运行了现有的MySQL服务器，那么解决此问题的最简单方法是安装Xampp服务器而不在安装时选择MySQL。

While installing the Xampp server, just untick the MySQL.

安装Xampp服务器时，只需解开MySQL即可。