phpmyadmin 从本地机器上的phpmysql连接到vagrant box上的mysql

ugmeyewa  于 2023-03-02  发布在  PHP
关注(0)|答案(1)|浏览(129)

我在本地运行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服务器"
有什么想法吗?

t1qtbnec

t1qtbnec1#

我想我遇到了多个问题。下面是我现在的配置:

流浪者文件

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'] = '127.0.0.1'; //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

除此之外,我还必须在MySQL上运行以下命令:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.2.2' IDENTIFIED BY 'password' WITH GRANT OPTION;

相关问题