如何更改phpmyadmin MySQL的ip地址？

Question

我在xampp中更改了apache的ip地址，但我无法连接到我的MySQL。我认为问题在于我的apache在我的数据库中不在同一个网络上。我的apache在192.168.1.10。而我的MySQL是127.0.0.1。请帮帮我。该怎么办呢。谢谢你。

Answer 1

在phpmyadmin文件夹中搜索config.inc.php

改变这一点

$cfg['Servers'][$i]['host'] = '127.0.0.1';

Answer 2

对于我安装的phpmyadmin版本(4.6.6)，配置文件位于

/etc/phpmyadmin/config-db.php

看起来是这样的：

<?php
##
## database access settings in php format
## automatically generated from /etc/dbconfig-common/phpmyadmin.conf
## by /usr/sbin/dbconfig-generate-include
##
## by default this file is managed via ucf, so you shouldn't have to
## worry about manual changes being silently discarded.  *however*,
## you'll probably also want to edit the configuration file mentioned
## above too.
##
$dbuser='phpmyadmin';
$dbpass='myrealpassword';
$basepath='';
$dbname='phpmyadmin';
$dbserver='localhost';
$dbport='3306';
$dbtype='mysql';

很明显，您只需将dbserver更改为127.0.0.1。如果您已经通过在mysql配置文件中设置skip-name-resolve=1来关闭mysql名称解析，这将特别有用。

/etc/mysql/mysql.conf.d/mysqld.cnf