{"id":9797,"date":"2020-01-31T05:35:22","date_gmt":"2020-01-31T05:35:22","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=9797"},"modified":"2021-11-13T05:59:35","modified_gmt":"2021-11-13T05:59:35","slug":"laravel-5-5-php-artisan-migrate-error-in-ubuntu-sqlstatehy000-2002-connection-refused","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/laravel-5-5-php-artisan-migrate-error-in-ubuntu-sqlstatehy000-2002-connection-refused\/","title":{"rendered":"Laravel 5.5 php artisan migrate error in Ubuntu: SQLSTATE[HY000] [2002] Connection refused"},"content":{"rendered":"\n

How I got this error?<\/strong>
Ans: <\/strong>I was running php artisan migrate<\/code><\/strong> command in \/opt\/lampp\/htdocs\/project_dir<\/code><\/p>\n\n\n\n

What was the error?<\/strong>
ubuntu@ip-ip_addr:\/opt\/lampp\/htdocs\/project_dir$ php artisan migrate
In Connection.php line 664:<\/code><\/p>\n\n\n\n

SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = db_name and table_name = migrations
)<\/code><\/p>\n\n\n\n

In Connector.php line 67:<\/code><\/p>\n\n\n\n

SQLSTATE[HY000] [2002] Connection refused<\/code><\/p>\n\n\n\n

Screenshot of the error:<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Solution:<\/strong>
1. Open .env<\/strong> file
2. Change the DB_HOST=127.0.0.1<\/code> to DB_HOST=localhost<\/strong>
3. Make sure the port number, db name, username and password is correctly mention in the .env before saving it
4. Save the .env file then run command: sudo artisan config:cache<\/code><\/strong>
5. Now, run command: php artisan migrate<\/code><\/strong><\/p>\n\n\n\n

Output after applying the solution:<\/strong> <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Thanks for reading. I hope you enjoyed the article!<\/p>\n\n\n