Access denied for user homestead localhost using password YES

Question

I m on a Mac OS Yosemite using Laravel 5 0  While in my local environment  I run php artisan migrate I keep getting    Access denied for user  homestead   localhost   using password  YES   Configuration Here is my  env APP ENV local APP DEBUG true APP KEY        DB HOST localhost DB DATABASE homestead DB USERNAME homestead DB PASSWORD secret  app config database php     mysql          gt         driver         gt   mysql        host           gt  env  DB HOST    localhost         database       gt  env  DB DATABASE    homestead         username       gt  env  DB USERNAME    homestead         password       gt  env  DB PASSWORD    secret         unix socket    gt    tmp mysql sock        charset        gt   utf8        collation      gt   utf8 unicode ci        prefix         gt           strict         gt  false         How do I avoid this kind of error   I ve tried    1 in app database php Replace localhost with 127 0 0 1  host   gt  env  DB HOST    localhost   -- gt  host    gt  env  DB HOST    127 0 0 1   Also  in  env DB HOST localhost  -- gt  DB HOST 127 0 0 1  2 Try specify environment php artisan migrate --env local  3 Check to see if the MySQL is running by run mysqladmin -u homestead -p status Enter password  secret I got Uptime  21281 Threads  3 Questions  274 Slow queries  0 Opens  327 Flush tables  1 Open tables  80 Queries per second avg  0 012 Which mean it s running   4 Check MySQL UNIX Socket  This step work for me

User · Answer

in my case  laravel 5   i had to wrap my password in single quotation marks and clear config cache   DB CONNECTION mysql DB HOST localhost DB PORT 3306 DB DATABASE database name DB USERNAME user name DB PASSWORD  password    and then run   php artisan config clear

User · Answer

You have to run the   php artisan migrate command from within Homestead  not your Mac

User · Answer

In my case the error was  caused  by my Homestead   Vagrant configuration about which I forgot    trying to run the migration just from command line   In case of using Homestead Vagrant Box environment you should run your migration from within your Homestead machine  after connecting to it using ssh  vagrant 192 168 10 10 22  then the access rights will be OK and will allow the migration to run

User · Answer

Check MySQL UNIX Socket Find unix socket location using MySQL mysql -u homestead -p mysql gt  show variables like   sock     ----------------------------------------- -----------------------------    Variable name                             Value                          ----------------------------------------- -----------------------------    performance schema max socket classes     10                              performance schema max socket instances   322                             socket                                     var run mysqld mysqld sock    ----------------------------------------- -----------------------------  3 rows in set  0 00 sec   Then I go to config database php I update this line    unix socket    gt    tmp mysql sock   to    unix socket      gt    var run mysqld mysqld sock   That s it  It works for my as my 4th try I hope these steps help someone   D

User · Answer

When you install Homestead  this creates a default  homestead    database in the VM  You should SSH into the VM homestead ssh and run   your migrations from there  If you are working locally with no VM    you ll need to create your database manually  By default  the database   should be called homestead  the username is homestead and the password   is secret    check this thread on laracasts or this blog post for more details     if you are getting    PDOException  SQLSTATE HY000   2002  No such file or directory   try changing  host  in the  app config database php file from  localhost  to  127 0 0 1    you can find more details and other fixes here on this thread    Also check whether you have specified the correct unix socket   check this thread

User · Answer

From your question  it seems you are running homestead  In that case  make sure you re running the commands in your VM  Many devs including me often make mistake and run artisan commands outside of VM which the commands will try to connect to our local database accessible through localhost which is different from the database used by homestead  Cd to your Homestead directory and run  vagrant ssh   then cd into code if that is where you keep your projects and cd into your project and run php artisan migrate again I hope this will help other people

User · Answer

i have  find solution    Go to your application root directory and open  env file  In ubuntu may be it   s hidden so press ctrl h to show hidden files  in your editor and change database configuration setting  then save your  env file then restart your apache server web server  and refresh your page and you have done If still issue try to run below command to clear the old configuration cache file    This  worked  for me   gl

User · Answer

A  After updating the  env file with database settings  clear larval setting by  running php artisan config clear    B  Please make sure you restart your apache server   rerun the  php artisan serve  command for your settings to take effect

User · Answer

If you have an error returning something like PDOException in Connector php line 55  SQLSTATE HY000   1049  Unknown database  laravelu  is due to you are changing your batabase config as DB DATABASE laravelu  So for now you either    Change the DB DATABASE  yourdatabase  or create a database called laravelu in your phpmyadmin   this should be able to solve it

User · Answer

All you have to do is alter your  env file   DB HOST localhost DB DATABASE homestead DB USERNAME homestead DB PASSWORD secret   In front of DB DATABASE  write the name of the database and in front of DB USERNAME  use root

User · Answer

Sometime in the future   Try to clear your config first   php artisan config clear     Close all the terminal  cmd windows and then restart terminal CMD and this should get rid of the error message  See if it works

User · Answer

if you are using php artisan migrate NOT from vagrant box but from host machine then you must define inside the  env the ip of the box 192 168 10 10  and obviously set permission to homestead user from your ip something like  grant all privileges on     to  homestead    identified by  secret     in  env file   DB HOST 192 168 10 10 DB DATABASE homestead DB USERNAME homestead

User · Answer

In Windows PC Follow below      Access the Root folder of your application  Edit the  env file       Edit the Highlighted and change the UserName and the password adn The database Name accordingly

User · Answer

i using laravel 5    i figure i have a file call  env in the root of the project that look something like this    APP ENV local APP DEBUG true APP KEY SomeRandomString  DB HOST localhost DB DATABASE homestead DB USERNAME homestead DB PASSWORD secret  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 MAIL ENCRYPTION null   And that was over writing the bd configuration so you can wheather deleted those config vars so laravel take the configuration under  config or set up your configuration here     I did the second and it works for me

User · Answer

TLDR  You need to stop the server Ctrl   c and start again using php artisan serve    Details   If you are using Laravel  and have started local dev server already by php artisan serve  And after having above server already running  you change your database server related stuff in  env file  Like moving from MySQL to SQLite or something  You need to make sure that you stop above process i e  Ctrcl C or anything which stop the process  And then restart Artisan Serve again i e  y php artisan serve and refresh your browser and your issue related to database will be fixed  This is what worked for me for Laravel 5 3

User · Answer

If you are using the PHP s default web server  e g  php artisan serve  you need to restart your server after changing your  env file values

User · Answer

I had the same issue and in the end It turned out that I just had to restart the server and start again   Ctrl   c then  php artisan serve

User · Answer

after config db restart the    php artisan serve   If the serve is active before set db config

User · Answer

Two way to solve it  First way  Not recommended   Open your database config file  laravel root config database php   amp  search for the below code block            host         gt  env  DB HOST    localhost             database     gt  env  DB DATABASE    blog             username     gt  env  DB USERNAME    root             password     gt  env  DB PASSWORD          Change the code block as below           host         gt   yourHostName            database     gt   YourDatabastName            username     gt   YoutDatabaseUsername            password     gt   YourDatabasePassword     Second way  Recommended by Laravel   Check your Laravel root there have a file call  env if not exist  look for  env example  copy rename it as  env after that the file looks blow    APP ENV local APP DEBUG true APP KEY someRandomNumber  DB HOST localhost DB DATABASE homestead DB USERNAME homestead DB PASSWORD secret  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   Modify the below block as follow  DB HOST yourHostName DB DATABASE yourDatabaseName DB USERNAME yourDatabaseUsername DB PASSWORD youPassword   Now it will work fine

User · Answer

in my case   after restarting my server the problem was gone   exit close the  php artisan serve  command and   re-run the command  php artisan serve  command

User · Answer

After change  env with the new configuration  you have to stop the server and run it again  php artisan serve   Cause laravel gets the environment when it s initialized the server  If you don t restart  you will change the  env asking yourself why the changes aren t taking place

User · Answer

I had the same issue using SQLite  My problem was that DB DATABASE was pointing to the wrong file location    Create the sqlite file with the touch command and output the file path using php artisan tinker      touch database database sqlite   php artisan tinker Psy Shell v0 8 0  PHP 5 6 27     cli  by Justin Hileman  gt  gt  gt  database path    database sqlite       gt    Users connorleech Projects laravel-5-rest-api database database sqlite    Then output that exact path to the DB DATABASE variable   DB CONNECTION sqlite DB HOST 127 0 0 1 DB PORT 3306 DB DATABASE  Users connorleech Projects laravel-5-rest-api database database sqlite DB USERNAME homestead DB PASSWORD secret   Without the correct path you will get the access denied error

User · Answer

Check your   env  file in the root folder  is it correct   DB CONNECTION mysql DB HOST 127 0 0 1 DB PORT 3306 DB DATABASE homestead DB USERNAME homestead DB PASSWORD secret

User · Answer

The reason of Access denied for user    homestead       localhost    laravel 5 error is caching-issue of the  env php file cause Laravel 5 is using environment based configuration in your  env file   1  Go to your application root directory and open  env file  In ubuntu may be it   s hidden so press ctrl h to show hidden files  amp  if you are in terminal then type   ls -a to show hidden files  in your editor and change database configuration setting  then save your  env file  DB HOST localhost DB DATABASE laravelu DB USERNAME root DB PASSWORD      2  then restart your apache server web server  and refresh your page and you have done  3  If still issue try to run below command to clear the old configuration cache file   php artisan config clear   Now you are done with the error

User · Answer

Check your  env file  if you have edited any of the variables  kindly restart laravel server  and your problem will be solved

User · Answer

just change these things in the  env file of your root folder     DB DATABASE your db name DB USERNAME your db user name DB PASSWORD  your db password      It worked for me

User · Answer

I just wanted to post this because this issue frustrated me for about 3 hours today  I have not tried any of the methods listed in the other answers  though they all seem reasonable  In fact  I was just about to try going through each of the above proposed solutions  but somehow I got this stroke of inspiration  Here is what worked for me to get me back working -- YMMV   1  Find your  env file  2  Rename your  env file to something else  Laravel 5 must be using this file as an override for settings somewhere else in the framework  I renamed mine to  env old 3  You may need to restart your web server  but I did not have to   Good luck

User · Answer

Log into MYSQL - use the mysql database   Select   from User   Make sure that your HOST column is correct  It should be the host that you are connecting from  your application server  be it IP address  or DNS name  Also     will work  meaning wildcard  but will not be secure

User · Answer

Got it  Log in as root and grant homestead localhost the rights to everything   From your terminal     homestead ssh    mysql -u root -p  Enter password  secret  mysql gt  grant all privileges on     to  homestead   localhost  identified by  secret    Query OK  0 rows affected  0 00 sec  exit   Now homesteads regular user has access to all of your tables  and as such  should be able to run things like migrations

[php] Access denied for user 'homestead'@'localhost' (using password: YES)

Examples related to php

Examples related to laravel

Examples related to laravel-5

Examples related to database-migration

Examples related to homestead