SQLSTATE HY000 2002 Connection refused within Laravel homestead

Question

Using Mac OS X and Homestead 2 2 1 with Laravel 5 2   In terminal  within homestead in my project folder  I can do php artisan to see all the available commands  When I try to run php artisan migrate I get a connection error  SQLSTATE HY000   2002  Connection refused    I have setup a Laravel project with these  env settings    DB HOST 127 0 0 1 DB DATABASE tcv DB USERNAME homestead DB PASSWORD secret   I have also tried localhost for DB HOST and root for DB USERNAME and DB PASSWORD  And all possible variations of these put together       In Sequel Pro  db management application  I CAN connect with these settings  Host       127 0 0 1 Username   homestead Password   secret Database   tcv Port       33060   But this database is obviously empty  because I cant migrate to it from terminal      As far as I can make out it is a configuration issue  since I can connect to it with Sequel Pro  But I have honestly no freaking idea what is setup wrong   Thanks for the help     EDIT For some reason I get the same SQLSTATE HY000   2002  Connection refused error when moving my project to MAMP and running php artisan migrate  Now I am completely lost

User · Answer

This is a simple fix  Your mysql database has lost its connection to the server  If you are running a local server run this in your terminal   mysqld   That will reconnect your database  Then  if you are using homebrew  run   brew services start mysql   This will automatically connect your database on login

User · Answer

I found that my server just needed to be restarted and  bam  it was fixed

User · Answer

If you are using MAMP on a mac OS add the following line to your mysql database config file   unix socket     env  DB SOCKET         and on your  env file add  DB SOCKET  Applications MAMP tmp mysql mysql sock

User · Answer

I had a similar problem and no suggestions placed here helped me  This what has fixed my problem was to set the application name and database hostname with the same value  In my case  127 0 0 1 works correctly   APP URL 127 0 0 1  DB CONNECTION mysql DB HOST 127 0 0 1 DB PORT 3306 DB DATABASE zzz DB USERNAME yyy DB PASSWORD XXX

User · Answer

I just ran into this and found that changing this in the  env file from 127 0 0 1 to localhost fixed it    DB HOST localhost

User · Answer

I encountered      SQLSTATE HY000   2002  Connection refused  SQL  select   from   projects    The cause was that I had not started the MySQL server   It may help to check that the MySQL is running as the first step in troubleshooting the error

User · Answer

If you are using Homestead like I do  do not forget to ssh into it before running artisan test for example

User · Answer

Another solution for anyone else who has a problem  I had all the settings correct but for some reason my changes weren t updated  Laravel actually caches the config file  which I find completely stupid    Here was my solution after updating the configs   php artisan config clear

User · Answer

For me enclosing the credentials in quotes did the trick  DB CONNECTION mysql DB HOST localhost DB PORT 3306 DB DATABASE  zzz  DB USERNAME  yyy  DB PASSWORD  XXX

User · Answer

Problem  In Laravel you have config database php where all the setup for the connection is located  You also have a  env file in the root directory in your project  which everyone uses for timesaving   This contains variables that you can use for the entire project   On a standard L5 project the MySql section of config database php looks like this        mysql    gt             driver       gt   mysql            host         gt  env  DB HOST    localhost             database     gt  env  DB DATABASE    forge             username     gt  env  DB USERNAME    forge             password     gt  env  DB PASSWORD                 charset      gt   utf8            collation    gt   utf8 unicode ci            prefix       gt               strict       gt  false           engine       gt  null           Notice there is no port set   Although in my  env file I had set DB PORT 33060  But that value  3306  was never read into the config database php  So don t be a dumbass like myself and forget to check the database php file    FIX Simply add  port    gt  env  DB PORT   3306   to your config database php and set that value in  env like this DB PORT 3306

User · Answer

Use localhost instead of 127 0 0 1  in your  env file   then run command    php artisan config cache

User · Answer

Okay update it seems the host is not the issue but actually the port   So its actually the port 3306 for the browser testing and yet for terminal and Sequel Pro 33060  Could it have something to do with adding it in the Homestead yaml and set it here   On reading the setup in relation to Laravel it says   MySQL  33060   Forwards To 3306

User · Answer

I was having this problem  When connecting with Sequel Pro  I need to use 33060 as the port  but in the  env file it has to be 3306  I had 33060 in the  env file  Changed it to 3306 and it worked

User · Answer

I had the same problem  try this works  DB HOST localhost

User · Answer

PROBLEM SOLVED  I had the same problem and fixed just by converting DB HOST constant in the  env File FROM 127 0 0 1 into localhost   JUST DO THIS AS GIVEN IN THE BELOW LINE  DB HOST   localhost   No need to change anything into config database php  Don t forget to run  php artisan config clear

User · Answer

DB CONNECTION mysql DB HOST mysql DB PORT 8080 DB DATABASE flap safety DB USERNAME root DB PASSWORD mysql   the above given is my  env        mysql    gt             driver    gt   mysql            url    gt  env  DATABASE URL             host    gt  env  DB HOST    mysql               port    gt  env  DB PORT    8080             database    gt  env  DB DATABASE    forge             username    gt  env  DB USERNAME    forge             password    gt  env  DB PASSWORD    mysql             unix socket    gt  env  DB SOCKET                 charset    gt   utf8mb4            collation    gt   utf8mb4 unicode ci            prefix    gt               prefix indexes    gt  true           strict    gt  true           engine    gt  null           options    gt  extension loaded  pdo mysql     array filter               PDO  MYSQL ATTR SSL CA   gt  env  MYSQL ATTR SSL CA                              the above given is my database php file  i just commented out port from database php and it worked for me

User · Answer

After you put all configuration on  env file  if you already run php artisan serve  RESTART IT

User · Answer

terminate sqld from task manager stop MySQL from xampp control panel and restart it   if it still throw the same problem  from root folder run  php artisan cache clear php artisan config cache php artisan serve    if you still have the problem  check whether you are using multiple copies of sql server  for example through Ubuntu app  if so stop the MySQL server in ubuntu  sudo service MySQL stop

User · Answer

In my case  I was having the same error using docker and the trick was in setting in the  env file this DB HOST db where db is the name of the container running the database server

User · Answer

Me  Im using vagrant  yet im executing php artisan outside the box so basically it doesn t have permission

User · Answer

In my case this error appeared out of blue  While staring at that mysterious error I ve realized  that I was trying to run the command outside of vm

User · Answer

It s possible that your mysql hasn t started or is not to the port 3306

User · Answer

When Laravel connects to mysql on Homestad box and running commands on local environment   DB HOST 127 0 0 1 the app needs DB PORT 3306 the migrations need DB PORT 33060 otherwise gives Connection refused phpunit needs DB PORT 33060 otherwise gives Connection refused  DB HOST localhost the app works with both DB PORT 3306 or DB PORT 33060 migrations cannot run phpunit cannot run  Have in mind that phpunit takes its values from the  env testing file  if exists  otherwise from the phpunit xml file on the root folder of the app

User · Answer

If you have your backend and database started on docker Instead of putting localhost or 127 0 0 1  as DB HOST put the name of the registered service that indicates your database service in the docker-compose file  In my case for example I replaced 127 0 0 1 with db because in my docker-compose file I had defined the name of the service for the database as db My docker-compose looks something like that services      db   lt ------ This is the name of the DB HOST       container name  admin db       image mysql 5 7 22

User · Answer

If you are using Homestead then you should be running it with the default mysql port  So instead of using DB PORT 33060  you should be using DB PORT 3306 in your  env file  Also  remember to run your php artisan migrate commands in your homestead installation and everything should be ok   Hope that helps

User · Answer

The only thing that solved it for me was to put the connection details in config database php instead of the  env file  Hope this helps

User · Answer

I could be because you might have not restarted PHP artisan since long  So After making DB changes and config clear Tinker works fine   But to make browser refect the new DB connection you need to re-run     php artisan serve

[php] SQLSTATE[HY000] [2002] Connection refused within Laravel homestead

Examples related to php

Examples related to laravel-5

Examples related to migration

Examples related to homestead

Examples related to laravel-artisan