我有两个Windows服务器与Mysql/phpmyadmin。一个是我目前的生产服务器，另一个将用于保存和备份生产（与复制D-1和D-7）
我的生产没有问题。
在复制，我需要绑定多个地址在my.ini当我安装了2个示例的Mysql，我已经尝试了2种方法来分离示例.
我改变端口没有绑定ip，它的工作。
如果我输入bind-address，就会出错。
我的服务是向上和工程，我已经把第二个ip地址对以太网高级tcp/ip配置。
我被阻止了，因为我不知道为什么绑定地址不起作用
谢谢大家!
我改变端口没有绑定ip，它的工作连接PHPmyadmin和MYSQL命令行
例如，我的ini D-1：

[client]
no-beep

port=3306

[mysqld]
# The TCP/IP Port the MySQL Server will listen on

port=3306
# Path to installation directory. All paths are usually resolved relative to this.
basedir=C:\Program Files\MySQL\MySQL Server 8.0\

# Path to the database root
datadir=D:\MySQLDatafiles\ 

myd7.ini D-7：

[client]
no-beep

port=3307

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3307
# Path to installation directory. All paths are usually resolved relative to this.
basedir=C:\Program Files\MySQL\MySQL Server 8.0j4

# Path to the database root
datadir=D:\MySQLDatafilesJ4

But when i put bind-address, Mysql Instance failed.

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306
bind-address=111.11.11.111
# Path to installation directory. All paths are usually resolved relative to this.
basedir=C:\Program Files\MySQL\MySQL Server 8.0j4

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306
bind-address=111.11.11.222
# Path to installation directory. All paths are usually resolved relative to this.
basedir=C:\Program Files\MySQL\MySQL Server 8.0j4

下面是错误：phpmyadmin上的连接

mysqli::real_connect(): (HY000/2002):
No connection could be established because the target computer expressly refused it

使用命令行连接mysql.exe：

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql 111.11.11.111 -u root -p
Enter password: *********
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql 111.11.11.222 -u root -p
Enter password: *********
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)

如果你需要更多信息我随时待命!