MySQL远程数据库服务器连接失败

Question

我正在尝试从我的本地计算机连接 Cakephp 3.x 远程数据库服务器。

但是显示如下错误

Error: SQLSTATE[HY000] [2002] No route to host

我在 app.php 中的本地数据库配置如下 -

'Datasources' => [
    'default' => [
        'className' => 'Cake\Database\Connection',
        'driver' => 'Cake\Database\Driver\Mysql',
        'persistent' => false,
        'host' => '192.168.1.19',
        /**
         * CakePHP will use the default DB port based on the driver selected
         * MySQL on MAMP uses port 8889, MAMP users will want to uncomment
         * the following line and set the port accordingly
         */
        'port' => '3306',
        'username' => 'remote_db_user',
        'password' => 'my_password',
        'database' => '********',
        'encoding' => 'utf8',
        'timezone' => 'UTC',
        'flags' => [],
        'cacheMetadata' => true,
        'log' => false,
     ],
     /*Other configs*/
]

关于远程服务器:

• ping 192.168.1.19 is ok for this IP from my PC
• There is no name server for this IP address

我该如何解决这个问题？

Answer 1

最后我按照一些步骤解决了这个问题-

第 1 步(编辑 mysql 配置文件)

/etc/mysql/mysql.conf.d/mysqld.cnf

查找并更改下行

bind-address = 127.0.0.1

到

bind-address = 0.0.0.0

第 2 步(授予用户数据库权限)

CREATE USER 'remote_db_user'@'%' IDENTIFIED BY 'my_password';

GRANT ALL PRIVILEGES ON *.* TO 'remote_db_user'@'%' WITH GRANT OPTION;

第 3 步(重启 Apache)

sudo service apache2 restart

第四步(重启mysql)

sudo service mysql restart

现在，我可以使用 CakePHP 3 连接远程数据库了