问题描述
我有使用 Laravel 4.2 构建的旧项目.我收到以下错误
I have old project which built using Laravel 4.2.I am getting following error
PDO 异常 (1045)SQLSTATE[HY000] [1045] 用户 'root'@'localhost' 访问被拒绝(使用密码:YES)
PDOException (1045) SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
我已经用谷歌搜索并尝试了每一个想法,但我无法解决它
I have googled and tried every think but i couldn't able to fix it
.env 文件
APP_KEY=az9tq5VHQCV9g5m2CsgY89jtijrCMgEA DB_HOST=localhost DB_DATABASE=billing DB_USERNAME=root DB_PASSWORD=1234
database.php
'mysql' => array( 'driver' => 'mysql', 'host' => 'localhost', 'database' => 'billing', 'username' => 'root', 'password' => '1234', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ),
谁能指导我哪里做错了?
Can any one guide me where m doing wrong ?
注意:在提出问题之前,我尝试更新 composer update 以及大多数 stackoverflow 答案.
Note: Before asking question i tried by updating composer update as well as most of the stackoverflow answers.
更新
我已经通过创建 php 文件测试了这个连接
I have tested this connection by creating php file
<?php $servername = "localhost"; $username = "root"; $password = "1234"; // Create connection $conn = new mysqli($servername, $username, $password); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; ?>
我会收到连接成功的消息
i will get Connected successfully message
推荐答案
Laravel 4.x 甚至不支持 ENV 文件.您只需要查看 ./config/[env name]/database.php 中的设置是否正确.
Laravel 4.x doesn't even support ENV files. You just have to see whether settings in ./config/[env name]/database.php are correct.