我在本地运行phpmysql,我想连接到安装在同一台机器上运行的MySQL示例。下面是相关的配置文件:
流浪者文件
config.vm.network "forwarded_port", guest: 3306, host: 33060
config.vm.network "forwarded_port", guest: 80, host: 8080, host_ip: "127.0.0.1"
config.vm.network "private_network", ip: "192.168.33.10"
phpMyAdmin/配置文件包含php
$j++;
$cfg['Servers'][$j]['host'] = '192.168.33.10:8080'; //provide hostname and port if other than default
$cfg['Servers'][$j]['port'] = '33060'; //provide hostname and port if other than default
$cfg['Servers'][$j]['user'] = 'root'; //user name for your remote server
$cfg['Servers'][$j]['password'] = 'password'; //password
$cfg['Servers'][$j]['auth_type'] = 'config'; // keep it as config
我还在vagrant box上设置了MySQL,以允许与以下内容进行远程连接:
文件夹/etc/mysql/my.cnf.
当我尝试从phpmyadmin连接时,我看到错误"mysqli::real_connect():(HY000/1130):不允许主机"10.0.2.2"连接到此MySQL服务器"
有什么想法吗?
1条答案
按热度按时间t1qtbnec1#
我想我遇到了多个问题。下面是我现在的配置:
流浪者文件
phpMyAdmin/配置文件包含php
除此之外,我还必须在MySQL上运行以下命令: