在 laravel 4.2 中，用户 'root'@'localhost' 的 Laravel 访问被拒绝(使用密码:YES) [英] 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

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 ?

注意:在提问之前，我尝试更新作曲家更新以及大多数 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";
?>

我将收到连接成功消息

推荐答案

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.

这篇关于在 laravel 4.2 中，用户 'root'@'localhost' 的 Laravel 访问被拒绝(使用密码:YES)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！