Laravel 7 SQLSTATE [HY000] [2002]连接被拒绝

咀嚼学院:

我的Laravel项目有问题。我是在几个小时前启动的,但遇到了SQL错误:

SQLSTATE[HY000] [2002] Connection refused
我已经呆了几个小时了,但我只发现密码或端口错误,但是我检查了一下,对我来说很好

这是.env文件:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3302
DB_DATABASE=test_technique
DB_USERNAME=root
DB_PASSWORD=

这是.env.example文件:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3302
DB_DATABASE=test_technique
DB_USERNAME=root
DB_PASSWORD=

这是database.php:

'mysql' => [
        'driver' => 'mysql',
        'url' => env('DATABASE_URL'),
        'host' => env('DB_HOST', 'localhost'),
        'port' => env('DB_PORT', '3302'),
        'database' => env('DB_DATABASE', 'test_technique'),
        'username' => env('DB_USERNAME', 'root'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'prefix_indexes' => true,
        'strict' => true,
        'engine' => null,
        'options' => extension_loaded('pdo_mysql') ? array_filter([
            PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
        ]) : [],
    ],

并检查mysql的端口:

Test for TCP
Your port 3302 is used by a processus with PID = 2292
The processus of PID 2292 is 'mysqld.exe' Session: Services
The service of PID 2292 for 'mysqld.exe' is 'N/A'
N/A means that there are no service related to PID 2292
Processus 'mysqld.exe' is launched by service 'wampmysqld64' with PID 5048

Test for TCPv6
Your port 3302 is used by a processus with PID = 2292
The processus of PID 2292 is 'mysqld.exe' Session: Services
The service of PID 2292 for 'mysqld.exe' is 'N/A'
N/A means that there are no service related to PID 2292
Processus 'mysqld.exe' is launched by service 'wampmysqld64' with PID 5048

我从未在mysql中更改过USERNAME和PASSWORD,所以我不知道为什么会出现此错误

PS:在另一个站点中,当我像这样使用PDO时,它可以工作:

new PDO("mysql:host=localhost:3302;dbname=test_technique;charset=utf8", "root", "",array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
Mudit Gulgulia:

MySQL的默认端口是3306而不是3302,除非已在php.ini中更改了端口,否则必须像这样使用

DB_PORT = 3306

运行此命令

php artisan config:clear

而不是使用

php artisan serve 

 php -S 127.0.0.1:8000 -t public/

这可能会有所帮助,因为如果您使用工匠服务并更改了env,则必须杀死该服务并再次运行。

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章

Laravel SQLSTATE [HY000] [2002]连接被拒绝| 锻造 AWS

Laravel Nova + Homestead SQLSTATE [HY000] [2002]连接被拒绝

RDS Laravel SQLSTATE[HY000] [2002] 连接被拒绝

Laravel:SQLSTATE [HY000] [2002]连接被拒绝

Laravel SQLSTATE [HY000] [2002]连接被拒绝,但修改过

PHP + MYSQL + Laravel - “SQLSTATE[HY000] [2002] 连接被拒绝”

SQLSTATE[HY000] [2002] 连接被拒绝 Laravel 8

Laravel 5.7 SQLSTATE[HY000] [2002] 无法建立连接

SQLSTATE [HY000] [2002]在laravel和docker设置中拒绝连接

SQLSTATE [HY000] [2002]在Docker中运行多个laravel项目时,连接被拒绝

Laravel:SQLSTATE HY000 2002无法建立连接,因为目标机器主动拒绝了它

SQLSTATE [HY000] [2002] Laravel宅基地内的连接被拒绝

如何修复 Laravel 中的“SQLSTATE[HY000] [2002] 连接被拒绝”错误(docker 中的工匠迁移)

PHP连接失败:SQLSTATE [HY000] [2002]连接被拒绝

SQLSTATE[HY000] [2002] 尝试将连接 Laravel 数据库添加到 Heroku 时连接被拒绝

Gitlab CI Symfony:SQLSTATE [HY000] [2002]连接被拒绝

PHP PDO:SQLSTATE [HY000] [2002]连接被拒绝

SQLSTATE [HY000] [2002]连接被拒绝。Laravel API使用WSL2 Ubuntu 18.04托管在Docker上

SQLState [HY000]与码头工人的连接拒绝Laravel

laravel迁移SQLSTATE [HY000]

SQLSTATE [HY000] [1040]连接太多

Laravel 遷移拋出“SQLSTATE[HY000] [2002] php_network_getaddresses”異常

Laravel 6.0 迁移 - SQLSTATE[HY000] [2002] 没有这样的文件或目录

Laravel 4和宝塔:[PDOException] SQLSTATE [HY000] [2002]没有这样的文件或目录

php artisan migration-SQLSTATE [HY000] [1045]用户'laravel'@'localhost'的访问被拒绝

Laravel 5错误SQLSTATE [HY000] [1045]用户'homestead'@'localhost'的访问被拒绝(使用密码:是)

Laravel身份验证:SQLSTATE [HY000] [1045]用户'root'@'localhost'的访问被拒绝(使用密码:NO)

Laravel 5错误SQLSTATE [HY000] [1045]用户'forge'@'localhost'的访问被拒绝(使用密码:NO)

SQLSTATE[HY000] [2002] 无法建立连接