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' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', 'localhost'), 'database' => env('DB_DATABASE', 'homestead'), 'username' => env('DB_USERNAME', 'homestead'), 'password' => env('DB_PASSWORD', 'secret'), 'unix_socket' => '/tmp/mysql.sock', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => 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'=> env('DB_HOST', 'localhost') -->'host' => env('DB_HOST', '127.0.0.1')

Also, in .env

DB_HOST=localhost --> DB_HOST=127.0.0.1

2

Try to specify the 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 means it's running.

4

Check MySQL UNIX Socket (This step work for me)

best practice would be to ensure that the account actually exists in mysql... "I found this key on the street, and it doesn't work in my front door lock. How can I change the lock to make the key work?" — Marc B
– Marc B, Commented Apr 20, 2015 at 19:06
I take it you're using the homestead VM? I have found that it will only work when you're in the VM. you can get onto it via ssh [email protected] -p 2222. my default machine doesn't twig that said db is running. — Jay Edwards
– Jay Edwards, Commented Sep 12, 2015 at 18:44

J4GD33P 51NGH · Accepted Answer · 2018-02-15 13:42:44Z

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 & 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

I worked for me thanks, one question why we have to set our db details on .env file as we do it on database.php file
maybe i you need multiple environment ,, production and local .
Kept trying to restart Apache when I was using "php artisan serve" the whole time, I would suggest you don't make the same mistake as me ><
Does not work, and now I get PDOException in Connector.php line 55: SQLSTATE[HY000] [1049] Unknown database 'laravelu' ._.
I tried changing .env and config:clear cache:clear all command, restarted apache but still getting the same problem.

webwizard · Accepted Answer · 2016-12-21 19:03:32Z

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

oh my god this worked for me thanks. but how can i stop when env changed is there any tools? this is good experience

abSiddique · Accepted Answer · 2016-07-24 23:52:02Z

Two way to solve it

First way (Not recommended)

Open your database config file (laravel_root/config/database.php) & search for the below code block.

 'host' => env('DB_HOST', 'localhost'), 'database' => env('DB_DATABASE', 'blog'), 'username' => env('DB_USERNAME', 'root'), 'password' => env('DB_PASSWORD', ''),

Change the code block as below

 'host' => 'yourHostName', 'database' => 'YourDatabastName', 'username' => 'YoutDatabaseUsername', 'password' => '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.

What's the point of this file? This information is in root/config/database.php seems redundant.
The information dose not redundant, it's using env function to read the value from the .env file to secure server information.
How do you find or create your host name, database name, username and password with Homestead?

wdog · Accepted Answer · 2015-12-11 16:47:29Z

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

I couldn't get that to work, but grant all privileges on *.* to 'homestead'@'localhost' identified by 'secret'; worked for me.

Vrushal Raut · Accepted Answer · 2017-03-27 10:57:45Z

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.

Keshan Nageswaran · Accepted Answer · 2016-12-08 18:51:04Z

12

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

edited Dec 8, 2016 at 18:51

Keshan Nageswaran

8,2064 gold badges30 silver badges45 bronze badges

answered Dec 8, 2016 at 16:16

124697

22k69 gold badges197 silver badges320 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:10:41Z

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 .

@rangerover.js try changing "host" in the /app/config/database.php file from "localhost" to "127.0.0.1"
@rangerover.js check this thread stackoverflow.com/questions/20723803/… . see any of the solutions matter.
@rangerover.js also check whether mysql service is running :)
@rangerover.js can check your unix_socket ? stackoverflow.com/a/25649930/939299
It finally work on the 4th tried. Please delete all your comments, and include this link stackoverflow.com/a/25649930/939299 as part of your answer because it help me.

Community · Accepted Answer · 2020-06-20 09:12:55Z

Check MySQL UNIX Socket

Find unix_socket location using MySQL

mysql -u homestead -p

mysql> 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' => '/tmp/mysql.sock',

to : 'unix_socket' => '/var/run/mysqld/mysqld.sock',

That's it. It works for my as my 4th try.I hope these steps help someone. :D

Fred Ondieki · Accepted Answer · 2017-06-29 10:41:30Z

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.

sh6210 · Accepted Answer · 2018-11-26 14:35:19Z

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.

mh. bitarafan · Accepted Answer · 2019-10-09 21:43:13Z

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

This solution work for me in Laravel 8 after a lot of other efforts. Thanks.

Krishneil · Accepted Answer · 2017-03-27 07:06:14Z

8

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.

edited Mar 27, 2017 at 7:06

answered Mar 27, 2017 at 6:54

Krishneil

1,4901 gold badge19 silver badges30 bronze badges

1 Comment

saber tabatabaee yazdi Over a year ago

thanks alot this is worked for me. i dont know why this error happened. i just close all and reload and run php artisan config:clear

A1Gard · Accepted Answer · 2018-08-06 20:33:24Z

6

after config db restart the:

 php artisan serve

If the serve is active before set db config.

answered Aug 6, 2018 at 20:33

A1Gard

4,1624 gold badges34 silver badges57 bronze badges

Comments

Jesus Gonzalez · Accepted Answer · 2015-10-29 16:03:39Z

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 :)

Mike Wright · Accepted Answer · 2015-12-11 15:48:12Z

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> 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.

Luis Lopez · Accepted Answer · 2017-11-23 10:59:28Z

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!!

Apoorv · Accepted Answer · 2018-11-22 16:40:00Z

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.

Eric Hepperle - CodeSlayer2010 · Accepted Answer · 2015-09-25 19:54:54Z

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!

Martin Bean · Accepted Answer · 2015-04-20 19:56:28Z

3

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

answered Apr 20, 2015 at 19:56

Martin Bean

39.6k28 gold badges134 silver badges207 bronze badges

1 Comment

Martin Bean Over a year ago

Your screen-shot shows the machine name as MBP-bheng-aveniors. That is not your VM. You need to SSH into Homestead ($ homestead ssh) and then run $ php artisan migrate from within that SSH session.

Ferhat KOÇER · Accepted Answer · 2016-07-02 12:49:47Z

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

DucaBgd · Accepted Answer · 2016-08-02 12:01:02Z

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 ...

sradha · Accepted Answer · 2019-07-02 04:43:00Z

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.

beiller · Accepted Answer · 2015-04-20 20:12:10Z

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.

Ogbonna Vitalis · Accepted Answer · 2017-12-19 08:47:56Z

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

Legionar · Accepted Answer · 2021-09-23 08:20:48Z

A. After updating the .env file with database settings, clear laravel 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.

Connor Leech · Accepted Answer · 2017-06-11 04:09:38Z

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 >>> database_path(‘database.sqlite’) => "/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

Byron Wong · Accepted Answer · 2017-06-28 08:28:03Z

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

Picard · Accepted Answer · 2019-08-03 20:40:53Z

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: [email protected]:22) then the access rights will be OK and will allow the migration to run.

Abdellah Ramadan · Accepted Answer · 2020-02-22 20:31:40Z

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.

watkib · Accepted Answer · 2021-07-15 09:27:13Z

My app had been set up to use .env.local. I was checking .env the whole time.

Check that you are editing the correct .env file if you have several.

Collectives™ on Stack Overflow

1

2

3

4

32 Answers 32

7 Comments

Details:

1 Comment

3 Comments

1 Comment

Comments

Comments

7 Comments

Check MySQL UNIX Socket

1 Comment

Comments

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related