在单独安装MySQL的同时使用XAMPP- phpmyadmin [英] Using XAMPP- phpmyadmin while Having Separate MYSQL installation

问题描述

我学习PHP.我在一台PC上安装了 XAMPP .

I study PHP.I'd a XAMPP installation on one of my PC.

我将 phpmyadmin 用于 mysql .

但是最近，我出于Java项目的目的安装了 MYSQL服务器.

But Lately, I installed MYSQL server for a java project purpose.

问题在于，现在我无法通过phpmyadmin浏览器访问mysql服务

The problem is that, now I can't access mysql services through phpmyadmin browser

界面.

显示错误. #2003 MYSQL错误.

有什么办法可以同时使用它们吗?

IS there any way that, I could use these both simultaneously?

因为，我已经习惯了这些?

Because, I'm used to be familiar with these ?

推荐答案

在另一个安装的mysql中使用xampp很容易.您需要做三件事:

using xampp with another installation of mysql is easy. you need to do 3 things:

1)在xampp/phpadmin/config.inc.php中进行以下更改:

1) in xampp/phpadmin/config.inc.php and make the following changes:

• 第21行更改密码
• 第31-32行将值更改为其他用户(例如20-21上列出的root用户)

2)进入xampp/mysql/data并复制phpmyadmin文件夹，然后将其复制到data文件夹以进行其他安装(注意:默认情况下，在Windows中，该文件夹位于一个名为program data的隐藏文件夹中，因此您需要以打开文件夹选项中的查看隐藏文件夹)，例如，在我的驱动器上为C:/ProgramData/MySQL/MySQL Server 5.5/data.将phpmyadmin文件夹复制到data文件夹中.这会将phpmyadmin表放入您的mySQL安装中.

2) go into xampp/mysql/data and copy the phpmyadmin folder and copy it to the data folder for the other installation (note: by default in windows this is in a hidden folder called program data, so you'll need to turn on view hidden folders in your folder options) so for example, on my drive it's C:/ProgramData/MySQL/MySQL Server 5.5/data. copy the phpmyadmin folder into the data folder. this will put the phpmyadmin tables into your mySQL installation.

3)重新启动一切

这不能解决所有问题，但可以让您从管理面板中访问/编辑表.需要复制/调整其他一些内容才能使其完美

this won't fix everything, but it will allow you to access/edit tables from within the admin panel. a couple of other things need to be copied/tweaked to get it perfect

这篇关于在单独安装MySQL的同时使用XAMPP- phpmyadmin的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！