Level 73
Can you connect to the database from the command line?
mysql -u root -p
Replace root with your mysql username if you have another one.
1 like
Jan 5, 2020
5
Level 4
Laravel 6.0 and PHP 7.4: SQLSTATE[HY000] [2002] No such file or directory
I just upgraded my PHP version from 7.2 to 7.4 and now whenever I try to run a query, I get this error. Here are my relevant .env credentials:
DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
I've tried as many have suggested and tried changing the DB_HOST to 127.0.0.1 and I get this error instead:
SQLSTATE[HY000] [2002] Connection refused
This is the first time I've ever performed a PHP upgrade. Is it normal to have issues like this? Particularly with Laravel?
Thanks
Level 4
Root is the only username I have. I tried connecting through the terminal and I got the following error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
Level 73
@greevesh try restarting the mysql service as it seems like it is not running at all. Or take a look at this answer here: https://stackoverflow.com/questions/11990708/error-cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysq
1 like
Level 73
Try restarting MySQL.
1 like
Level 4
All I needed to do was start MySQL. That would explain why the restart commands weren't working. I never disconnected from MySQL manually but I read on SO that if you have multiple instances of MySQL, problems like these can take place. This makes sense as I recently installed XAMMP.
Maybe it wasn't the PHP upgrade after all.
Thank you both.
Please or to participate in this conversation.