SQLSTATE[HY000] [2002] Connection refused on Laravel Server

Asked Apr 29 '21 at 07:54

Active Apr 29 '21 at 09:26

Viewed 127 times

I have a laravel site hosted on a server and when I log in, it usually load but today i see that it says connection refused.

SQLSTATE[HY000] [2002] Connection refused (SQL: select * from `users` where `email` = admin12345@gmail.co.za limit 1)

has anyone experienced this?

my env file:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=database1
DB_USERNAME='root'
DB_PASSWORD='123456789'

I have changed `DB_HOST=127.0.0.1` to `DB_HOST=localhost` but still no success

asked Apr 29 '21 at 07:54

Juststartedcoding

Why have a single quote like this `DB_USERNAME='root'` when you can just add `DB_USERNAME=root` – Apr 29 '21 at 08:05
Not sure if it will fix the issue, but the .env may not recognize the `'` as a quote and try to parse it – Apr 29 '21 at 08:06
@DevinGray the program refuses to run if the quotes are not there – Juststartedcoding Apr 29 '21 at 08:07
can you try with `DB_USERNAME="root"` – Apr 29 '21 at 08:07
@DevinGray password too? – Juststartedcoding Apr 29 '21 at 08:08
Yes, I know in my .env I always use double quotes, if not working after that then the error is somewhere else – Apr 29 '21 at 08:08
let me try that – Juststartedcoding Apr 29 '21 at 08:10
@DevinGray Still no result – Juststartedcoding Apr 29 '21 at 08:11
Lets start a chat I can help – Apr 29 '21 at 08:11
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/231728/discussion-between-devin-gray-and-juststartedcoding). – Apr 29 '21 at 08:12
you can try `php artisan config:cache` to clear the cache of config. – GhanuBha Apr 29 '21 at 08:13
did you install PHP pdo_mysql? – Turan Zamanlı Apr 29 '21 at 08:38
@TuranZamanlı no i have not – Juststartedcoding Apr 29 '21 at 08:49
https://stackoverflow.com/questions/35394230/sqlstatehy000-2002-connection-refused-within-laravel-homestead – Turan Zamanlı Apr 29 '21 at 11:10
@TuranZamanlı i have the port numbers included, but still nothing works – Juststartedcoding Apr 29 '21 at 11:18
Did you check your mysql connection with terminal ? or with telnet ? – Turan Zamanlı Apr 29 '21 at 11:23
it seems my sql needs to be restarted but it refuses to saying unit not found – Juststartedcoding Apr 29 '21 at 11:28
@TuranZamanlı Unit mssql-server.service could not be found. – Juststartedcoding Apr 29 '21 at 11:30
you need to instal MySQL, not mssql. – Turan Zamanlı Apr 29 '21 at 13:08

SQLSTATE[HY000] [2002] Connection refused on Laravel Server

0 Answers0