By Code Ideas
I followed all the steps to connect my database to my Laravel Application, including connecting to mysql using the terminal and using the connection parameters. I am able to see all of the database tables in the terminal. But, when I try to log into my application on the web, or run php artisan migrate, I get the following message: SQLSTATE[HY000] [2002] No such file or directory
SELECT * FROM users WHERE email = info@example.com. I am assuming this is because my database is not connected.
Here are my .env values:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=testing
DB_USERNAME=username
DB_PASSWORD=protected
My app-level environment variables:
APP_NAME: App
APP_KEY: Key values
DB_CONNECTION: mysql
DB_HOST: 127.0.0.1
DB_PORT: 25060
DB_DATABASE: defaultdb
DB_USERNAME: username
DB_PASSWORD: password
APP_DEBUG: true
SSL_MODE: REQUIRED
Any help would be appreciated. Thank you.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi @codeideas,
Usually, the error is caused when you use DB_HOST=localhost instead of DB_HOST=127.0.0.1.
Additionally, restart you MySQL instance and try to enter using the credetianls of your application(not sure how did you logged in to MySQL before with root or with the laravel user).
Hello @codeideas
You can try to connect to the database via terminal/shell with the mysql command. This will give you the opportunity to test if the login credentials are correct.
Regards
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.