Laravel 5 error SQLSTATE HY000 1045 Access denied for user homestead localhost using password YES

Question

I have installed Laravel 5 successfully and changed MySQL credentials in database php file in config directory to        mysql    gt                 driver       gt   mysql                host         gt  env  DB HOST    localhost                 database     gt  env  DB DATABASE    wdcollect                 username     gt  env  DB USERNAME    root                 password     gt  env  DB PASSWORD                     charset      gt   utf8                collation    gt   utf8 unicode ci                prefix       gt                   strict       gt  false               I don t want to use homestead and I have changed  env file to  APP ENV local APP DEBUG true APP KEY apLIzEMOgtc5BUxdT9WRLSvAoIIWO87N  DB HOST localhost DB DATABASE wdcollect DB USERNAME root DB PASSWORD   CACHE DRIVER file SESSION DRIVER file QUEUE DRIVER sync  MAIL DRIVER smtp MAIL HOST mailtrap io MAIL PORT 2525 MAIL USERNAME null MAIL PASSWORD null   I don t understand that why it s saying that access denied for  homestead   localhost

User · Answer

Jeez  Thanks to umair ashfr answer here below  I finally hit the nail with an issue that was eating my neurons  I had a password like DB PASSWORD ffjdh5 fgr on my  env  and MySQL connection was gracefully saying that  quot SQLSTATE HY000   1045  Access denied for user    quot   no matter what flavor of php artisan I was trying to run  The problem was that  quot   quot  sign inside the password  BEWARE  That means the start of a comment  thus my password was silently truncated  The solution is to declare password like DB PASSWORD  quot ffjdh5 fgr quot  Regards

User · Answer

I had the same problem  so I realized that the  env file does not accept special characters  as my password has these characters  I added the password in the config database php file

User · Answer

Declare password like DB PASSWORD  quot 2o0  5TGR1NG quot  in  env file If   sign include in your password then password will declare in between  quot   quot

User · Answer

This works to me   php artisan config clear php artisan cache clear php artisan config cache   Thanks

User · Answer

I Faced Same Problem what i did    php artisan cache clear  php artisan config cache   but Same problem found than i run this artisan command  php artisan view clear  Hope it will helpful

User · Answer

in my case I wanted to connect to the database installed on windows that i used to access through workbench  so i replaced localhost with the ip address which i obtained by typing ipconfig on windows command prompt

User · Answer

Try to checkout the   env  file in your root directory  It will be a hidden file  Correct these values    DB HOST localhost  DB DATABASE homestead  DB USERNAME homestead  DB PASSWORD secret

User · Answer

I spent hours on this  -  and finally  it was really easy to hack BEFORE DB PASSWORD  Root2020   UPDATED DB PASSWORD  quot  Root2020  quot   I think the problem was   in the password  that s why I had to write my password into quotation marks

User · Answer

Reason is the old database credentials are cached  bootstap cache config php  In the  env file  I modified it as follow    DB HOST localhost  DB DATABASE homestead  DB USERNAME homestead  DB PASSWORD secret   Then removed that file   bootstap cache config php    If the issue still there you might try the following   php artisan config clear php artisan cache clear php artisan config cache  Exit vagrant by writing the exit command Then restart vargarnt homestead config   vagrant reload --provision   Then opened vagrant again   Vagrant Up Vagrant ssh

User · Answer

Instead of using this  DB HOST localhost DB DATABASE wdcollect DB USERNAME root DB PASSWORD    USE this  DB HOST localhost DB DATABASE wdcollect DB USERNAME root DB PASSWORD

User · Answer

You do not need to set credentials in database php file  It is enough if you have credentials in  env  If you are able to login to database directly then this password must work  It can be possible that you are having different environment than  local  which is defined in this file  Test is with  php artisan env

User · Answer

I came up with this too    then I solve it by putting the database information directly in    database php    In your case  I would change the information like this  mysql    gt             driver       gt   mysql            host         gt   localhost            database     gt   wdcollect            username     gt   root            password     gt               charset      gt   utf8            collation    gt   utf8 unicode ci            prefix       gt               strict       gt  false           and don t forget to change your setting in XAMPP s config inc    auth type      config     Servers    i   user      root     Servers    i   password           AllowNoPassword     true

User · Answer

None of these worked for me when I deployed my website online on shared hosting  below is what I did that worked   In the  env file  I changed   DB HOST 127 0 0 1   to   DB HOST localhost   and viola  it worked well as expected

User · Answer

You need to run these two commands  php artisan cache clear php artisan config cache

User · Answer

Open terminal on XAMPP   go to  opt lampp htdocs project name   run php artisan migrate   env file   DB CONNECTION mysql DB HOST localhost DB PORT 8080 DB DATABASE database name DB USERNAME root DB PASSWORD

User · Answer

Edit the file  env in your laravel root directory  make looks as in below      DB HOST localhost  DB DATABASE laravel  DB USERNAME root  DB PASSWORD your-root-pas  Also create one database in phpmyadmin named   laravel   Run below commands     php artisan cache clear  php artisan config cache  php artisan config clear     php artisan migrate    It worked for me  XAMPP with Apache and MySQL

User · Answer

I was facing the same issue  Everything was fine but in      bootstrap cache config php   always had the incomplete password  Upon digging further  realized that the password had     character in it and that was getting dropped  As     is used to mark a line as a comment

User · Answer

The  env file should have same database name   username and password as in the mysql database and check whether all permissions are granted to the user for accessing the database or not  I solved my problem by adding the cpanel username in front of database name and username like jumbo admingo and jumbo user1 respectively where jumbo is my cpanel username and admingo is the database name i created in mysql and user1 is the user which has been provided the access to the database admingo  THIS SOLVED MY PROBLEM

User · Answer

Please update below file   vendor -  env - on line 7   DB HOST localhost  DB DATABASE homestead  DB USERNAME homestead  DB PASSWORD secret   Instead of homestead user your database  username and password  This should work for you

User · Answer

if you before use localhost and root your file be cached  remove  bootstap cache config php

User · Answer

In my case  it was actually root user permission problem  My Laravel configurations were all perfect  but later I found that it was root user permission problem since my MySQL configs were somehow changed   so i navigated to xampp folder  gt  C  xampp mysql bin searched for my ini file and opened it in editor then added added skip-grant-tables in following place    mysqld  skip-grant-tables port 3306 and it worked

User · Answer

It s working now  I had to restart server   Thanks

User · Answer

If you are on MAMP  Check your port number as well generally it is  Host localhost  Port 8889  User root  Password root  Socket  Applications MAMP tmp mysql mysql sock

User · Answer

Match the  env file and the config php file with your username and password and your hostname in the database settings if they are not equal relation will not connect

User · Answer

Pls Update  env file   DB HOST localhost  DB DATABASE homestead  DB USERNAME homestead  DB PASSWORD secret      After then restart server

[php] Laravel 5 error SQLSTATE[HY000] [1045] Access denied for user 'homestead'@'localhost' (using password: YES)

Examples related to php

Examples related to database

Examples related to xampp

Examples related to localhost

Examples related to laravel-5