无法使用 Laravel 5 实时连接到 MySQL [英] Can't connect to MySQL on live with Laravel 5

问题描述

我在将 Laravel 5 连接到实时服务器上的 MySQL 时遇到问题，在本地主机上似乎没问题，但是当我将它上传到实时服务器时，它不会连接说:

I have problem on connecting Laravel 5 to MySQL on live server, it seems ok on localhost but when I uploaded it to live server, it wont connect saying:

Connector.php 第 47 行中的 PDOException: SQLSTATE[HY000] [2003] 无法连接到10.0.0.131"上的 MySQL 服务器 (111)

PDOException in Connector.php line 47: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '10.0.0.131' (111)

这是我的配置

本地服务器:

config/database.php

'mysql' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST', '127.0.0.1'),
            'database'  => env('DB_DATABASE', 'MY_DATABASE_NAME'),
            'username'  => env('DB_USERNAME', 'MY_USERNAME'),
            'password'  => env('DB_PASSWORD', 'MY_PASSWORD'),
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
],

.env

APP_ENV=local
APP_DEBUG=true
APP_KEY=0jxkNPPT1PVVx0sFdMpxfVeqe5C24HLP

DB_HOST=127.0.0.1
DB_DATABASE=MY_DATABASE_NAME
DB_USERNAME=MY_USERNAME
DB_PASSWORD=MY_PASSWORD

CACHE_DRIVER=file
SESSION_DRIVER=file

<小时>

实时服务器:

config/database.php

'mysql' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST', '10.0.0.131'),
            'database'  => env('DB_DATABASE', 'MY_DATABASE_NAME'),
            'username'  => env('DB_USERNAME', 'MY_USERNAME'),
            'password'  => env('DB_PASSWORD', 'MY_PASSWORD'),
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
],

.env

APP_ENV=local
APP_DEBUG=true
APP_KEY=0jxkNPPT1PVVx0sFdMpxfVeqe5C24HLP

DB_HOST=10.0.0.131
DB_DATABASE=MY_DATABASE_NAME
DB_USERNAME=MY_USERNAME
DB_PASSWORD=MY_PASSWORD

CACHE_DRIVER=file
SESSION_DRIVER=file

推荐答案

这似乎不是配置错误，假设您确实想连接到 10.0.0.131 而您没有更改默认监听端口.因为客户端尝试连接到您指定的数据库，但由于连接被拒绝错误而无法连接，这告诉您存在潜在的 TCP 问题.

It doesn't seem to be a configuration error, assuming you did want to connect to 10.0.0.131 and you did not change the default listening port. because the client tries to connect to the database you specified, but it can't due to a connection refused error, which tells you that there is an underlying TCP problem.

可能的情况是:

1. 服务未运行
2. 服务未侦听外部连接
3. 防火墙阻止连接
4. 网络问题

您应该尝试登录到远程服务器，然后从那里通过一些 shell 命令连接到您的数据库以验证您是否真的可以.

You should try to log in to your remote server and, from there, connect to your database via some shell command to verify you actually can.

这篇关于无法使用 Laravel 5 实时连接到 MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！