我的 Laravel 項目有問題。我幾個小時前開始使用它,但遇到了 SQL 錯誤:SQLSTATE[HY000] [2002] 連接被拒絕我已經搜索了幾個小時,只發現密碼錯誤或端口錯誤,但我檢查了一下,這對我來說沒問題。這是 .env 文件:DB_CONNECTION=mysqlDB_HOST=localhostDB_PORT=3302DB_DATABASE=test_techniqueDB_USERNAME=rootDB_PASSWORD=這是 .env.example 文件:DB_CONNECTION=mysqlDB_HOST=localhostDB_PORT=3302DB_DATABASE=test_techniqueDB_USERNAME=rootDB_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 TCPYour port 3302 is used by a processus with PID = 2292The processus of PID 2292 is 'mysqld.exe' Session: ServicesThe service of PID 2292 for 'mysqld.exe' is 'N/A'N/A means that there are no service related to PID 2292Processus 'mysqld.exe' is launched by service 'wampmysqld64' with PID 5048Test for TCPv6Your port 3302 is used by a processus with PID = 2292The processus of PID 2292 is 'mysqld.exe' Session: ServicesThe service of PID 2292 for 'mysqld.exe' is 'N/A'N/A means that there are no service related to PID 2292Processus 'mysqld.exe' is launched by service 'wampmysqld64' with PID 5048我從未更改過 mysql 中的用戶名和密碼,所以我不知道為什么會出現此錯誤PS:在另一個站點中,當我像這樣使用 PDO 時,它可以工作:new PDO("mysql:host=localhost:3302;dbname=test_technique;charset=utf8", "root", "",array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
1 回答

慕標5832272
TA貢獻1966條經驗 獲得超4個贊
MySQL 的默認端口是 3306 而不是 3302,除非您在 php.ini 中更改了端口,否則您必須這樣使用
DB_PORT = 3306
運行這個命令
php artisan config:clear
而不是使用
php artisan serve
使用
php -S 127.0.0.1:8000 -t public/
這可能會有所幫助,因為如果您使用 artisanserve 并對 env 進行更改,您必須終止該服務并再次運行。
- 1 回答
- 0 關注
- 217 瀏覽
添加回答
舉報
0/150
提交
取消