Level 75
Try localhost instead of 127.0.0.1 Also try stopping and restarting mysql. And clear your config.
php artisan config:clear
May 8, 2020
4
Level 1
SQLSTATE[HY000] [2002] Connection refused
Im working in a mac, I have tried everything and still the error.
Note: ProductController.php works fine until trying to return database info.
This is my .env:
APP_URL=http://localhost
LOG_CHANNEL=stack
DB_CONNECTION=mysql DB_HOST=localhost DB_PORT=3306 DB_DATABASE=laravel5 DB_USERNAME=root DB_PASSWORD=''
This is my database.php 'mysql' => [ 'driver' => 'mysql', 'url' => env('DATABASE_URL'), 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'laravel5'), 'username' => env('DB_USERNAME', 'root'), 'password' => env('DB_PASSWORD', ''),
Can't find the error please help!
Level 1
Hi @jlrdw did just that, and now it appears SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from products)
Level 75
Are you able to connect to mySQL with phpmyadmin or another front end. And Run a simple query.
Level 75
See this also. https://laracasts.com/discuss/channels/laravel/sqlstatehy000-2002-no-such-file-or-directory-sql-select-count
and try changing back to 127.0.0.1 and restarting server and clearing the config.
Sometimes localhost works sometimes the other. it's got to be a setting somewhere.
Please or to participate in this conversation.