Zend_Db:如何通过SSH隧道连接到MySQL数据库? [英] Zend_Db: How to connect to a MySQL database over SSH tunnel?

问题描述

如何使用PHP和Zend Framework连接到需要SSH隧道的MySQL数据库?

How can I connect to a MySQL database that requires an SSH tunnel using PHP and the Zend Framework?

推荐答案

只需启动SSH隧道并将本地端口用作MySQL端口即可.

Just start up SSH tunnel and use the local port as your MySQL port.

例如，您以这种方式启动隧道，

For example, you start tunnel as this,

ssh -f [e-mail] -L 3306:mysql-server.com:3306 -N

您可以像这样连接到MySQL

And you can connect to MySQL like this,

$conn = mysql_connect('localhost', 'mysql_user', 'mysql_password');

对于zend_db，您可以这样做

For zend_db, you do this,

$config = new Zend_Config(
    array(
        'database' => array(
            'adapter' => 'Mysqli',
            'params'  => array(
                'host'     => 'localhost',
                'dbname'   => 'my_db',
                'username' => 'mysql_user',
                'password' => 'mysql_password',
            )
        )
    )
);

$db = Zend_Db::factory($config->database);

这篇关于Zend_Db:如何通过SSH隧道连接到MySQL数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！