Unable to connect to local MySQL DB using Laravel

Question

I have a local database that I can connect to no problem using straight php

However, when I use the same settings in Laravel, I get an access denied error message

I checked stackoverflow for this type of error and most cases is solved by using 127.0.0.1. I made sure to try both 127.0.0.1 and localhost whenever asked for host/server.

Also, I made sure root had sufficient privileges

Here are my configuration settings, I tried to use different accounts, other than root, and also changing 127.0.0.1 to localhost (and the opposite)

database.php file

.env file

Hoping to learn this framework, I've heard great things. Appreciate any help

Answer 1

Sounds like you are trying the connection both with the script and laravel from a different Server like homestead.

Normally there are restrictions that you can't connect from remote (i.e. from a VM like homestead) to a certain server (i.e. localhost) with the root user.

Possible Solutions: 1. Create another user with the relevant permissions on mysql and connect with that one. 2. Look in the web for how to allow remote connections 3. Go the laravel way and use the homestead DB inside of the VM