Support the ongoing development of Laravel.io →
Configuration Database Laravel

Illuminate\Database\QueryException : SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = LaravelBlog; and table_name = migrations and table_type = 'BASE TABLE')

I get still this kind of error after typing: "php artisan migrate" in sudo mode.

Here is mine first lines of .env file: APP_NAME=Laravel APP_ENV=local APP_KEY=base64:XJz8GyJdyJc4KIG/Pdi9uhbzT+uP/BdLd7ftv+VgoDk= APP_DEBUG=true APP_URL=http://localhost

LOG_CHANNEL=stack

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=LaravelBlog; DB_USERNAME=root DB_PASSWORD= UNIX_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock

Tried to change DB_PORT number(into 33060),DB_HOST from 127.0.0.1 to localhost, put in UNIX_SOCKET(dont know if it works with or without it) As a programming starter(after basic Java course) i feel that mine possibilitties are at the end of road. Can i get help from anyone to overcome those issues?

I can give any additional information to post If this can be a hint im using VirtualBox Ubuntu 18

Thanks

Last updated 3 years ago.
0

Is there really a semicolon after the "DB_DATABASE=LaravelBlog"?

0

Sign in to participate in this thread!

Eventy

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.