mysql - 多个数据库连接失败，Connector.php 第 47 行中的 PDOException SQLSTATE[HY000] [2002] 连接尝试失败

Question

我正在尝试从本地主机连接远程数据库，因为我想将本地主机数据存储到远程服务器。现在我想简单地显示从本地主机获取的用户表信息和不同的变量显示远程服务器用户表信息。我在这里编写代码示例:

在我的 Config/database.php 中:

'mysql' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', 'localhost'),
        'database'  => env('DB_DATABASE', 'realstate'),
        'username'  => env('DB_USERNAME', 'root'),
        'password'  => env('DB_PASSWORD', ''),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],

    'shahin' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', '104.219.248.3'),
        'database'  => env('DB_DATABASE', 'laraveldb'),
        'username'  => env('DB_USERNAME', 'laraveldb_username'),
        'password'  => env('DB_PASSWORD', 'secret'),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],

在 Route.php 中:

Route::get('mpdb',function(){
      $userArray = DB::table('users')->get();
      echo "<pre>";
      print_r($userArray);
      echo "</pre><br>";           
      $users2 = DB::connection('shahin');
      $u = $users2->table('users')->get();
      echo "<pre>";
      print_r($u);
});

本地数据库工作正常，但远程数据库出错!!

ERROR : SQLSTATE[HY000] [2002] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Answer 1

要允许外部 Web 服务器访问您的 MySQL 数据库，请将其域名添加到能够访问您网站上的数据库的主机列表中。 see a hosted cpanel demo(Image)

如果您想要所有传入主机，您可以像这样访问 %.%.%.%你可以看这张图 How to permit other incoming host(Image)