Laravel 4.2中用户'root'@'localhost'的Laravel访问被拒绝(使用密码:是) [英] Laravel Access denied for user 'root'@'localhost' (using password: YES) in laravel 4.2
问题描述
我有一个使用Laravel 4.2构建的旧项目.我正在跟踪错误
I have old project which built using Laravel 4.2.I am getting following error
PDOException(1045) SQLSTATE [HY000] [1045]用户'root'@'localhost'的访问被拒绝(使用密码:是)
PDOException (1045) SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
我用Google搜索并尝试了所有想法,但我无法解决
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 ?
注意:在提出问题之前,我先尝试通过更新作曲家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/[环境名称]/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.
这篇关于Laravel 4.2中用户'root'@'localhost'的Laravel访问被拒绝(使用密码:是)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!