php artisan migration-SQLSTATE [HY000] [1045]用户'laravel'@'localhost'的访问被拒绝 [英] php artisan migrate - SQLSTATE[HY000] [1045] Access denied for user 'laravel'@'localhost'

问题描述

我想按照本课程设置并学习Laravel

I want to set up and learn Laravel following this course

当我尝试使用命令 php artisan migration 时，出现此错误:

When I try to use the command php artisan migrate I get this error:

[Illuminate\Database\QueryException]                                                                                                        
  SQLSTATE[HY000] [1045] Access denied for user 'laravel'@'localhost' (using password: NO) (SQL: select * from information_schema.tables whe  
  re table_schema = laravel and table_name = migrations)

[PDOException]                                                                            
  SQLSTATE[HY000] [1045] Access denied for user 'laravel'@'localhost' (using password: NO)

我一直在寻找答案.我认为可能必须在 .env 文件中进行一些更改，但我不知道是什么，到目前为止我没有尝试过.

I have looked for answers. I figured I may have to make some changes in the .env file, but I don't know what, and nothing I have tried so far has worked.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=laravel
DB_PASSWORD=

我使用的是Ubuntu 16.04，而不是视频中的Mac OS X，所以我想知道该怎么做?有一些我没有正确设置的MySQL设置吗?

I'm using Ubuntu 16.04, not a Mac OS X as in the video, so I wonder what should I do differently? Is there some MySQL setting I did not set correctly?

推荐答案

您没有名为"laravel"的用户.您应该将DB_USERNAME更改为实际用于访问数据库的数据库.通常，默认情况下它是根目录，因此.env中的更改应为

You don't have a user named 'laravel'. You should change the DB_USERNAME to the one you're actually using to access your DB. Mostly it's root by default so the changes in .env should be

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=

这篇关于php artisan migration-SQLSTATE [HY000] [1045]用户'laravel'@'localhost'的访问被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！