duanqianhuan3994 2014-09-24 22:35
浏览 39

无法从guest虚拟机连接到主机的数据库

In Ubuntu 12.04 guest on Windows 8.1 host (using VirtualBox), a cloned application cannot connect to the host's database. Regardless of settings in parameter.yml the following occurs at login:

SQLSTATE[28000] [1045] Access denied for user 'projectmana'@'localhost' (using password: YES)

NB: login credentials are different from database credentials.

parameters.yml (in part)

database_driver: pdo_mysql
database_host: 192.168.168.205
database_port: null
database_name: projectmana
database_user: root
database_password: root's password

I have confirmed that guest OS has pdo_mysql installed. MySQL client in guest OS can connect to mysql at host's address with either root or projectmana credentials. I have also attempted the solution of adding PDO parameters as shown here without success.

Update

I've also confirmed that PDO can connect to the host via

<?php
$dsn = 'mysql:dbname=projectmana;host=192.168.168.205';
$user = 'root';
$password = 'some password';

try {
    $dbh = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
    exit;
}

echo "We're connected!";
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 求差集那个函数有问题,有无佬可以解决
    • ¥15 【提问】基于Invest的水源涵养
    • ¥20 微信网友居然可以通过vx号找到我绑的手机号
    • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
    • ¥15 解riccati方程组
    • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
    • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
    • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
    • ¥50 树莓派安卓APK系统签名
    • ¥65 汇编语言除法溢出问题