I am trying to set up a laravel project in phpstorm but fail at connecting to a mysql database. These are the steps I've taken so far:
- download and install
composer, vagrant and virtualbox
- create
laravel/laravel project with composer (create composer project in phpstorm)
- integrate
laravel/homestead with composer: composer require laravel/homestead --dev
- build homestead in
root dir: vendor\\bin\\homestead make (windows)
- personalize my local domain by setting it in
Homestead.yaml -> sites -> map: mydomain.com
- integrated the domain in
c:/windows/system32/drivers/etc/hosts: 192.168.10.10 mydomain.com
- create empty
ssh key for vagrant to run: fsutil file createnew C:/Users/<username>/.ssh/id_rsa 0
- start
VM with vagrant: vagrant up
So far so good, everything seems to work. And here comes the problem:
- create
mysql database with phpstorm's integrated database tool, using .env as reference (DB_CONNECTION=mysql, DB_HOST=127.0.0.1, DB_PORT=3306, DB_DATABASE=laravel, DB_USERNAME=root, DB_PASSWORD=devpw)
After installing drivers when trying to test connect:
[08S01]
Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Or in the log:
java.net.ConnectException: Connection refused: connect.
I've been trying to find a fix for some time now without success. This Thread seems to provide solutions, many of which I am not sure how to implement, since they are not directed at phpstorm. I feel a bit overwhelmed by the whole backend thing and how to set it up right in laravel.
Am I supposed to install mysql on windows before integrating it into phpstorm?