Configure DB connection in PhpStorm

[paliarush]

[luke-denton-aligent]

Is this something you plan on doing? I've been trying to set up the PHPStorm database for a while now but I just can't get it to work!

These are the steps I've followed:

Add new database source Select SSH/SSL Tab, Use SSH tunnel Proxy host: 127.0.0.1 Port: [as configured in config.yaml] Proxy user: vagrant Proxy password: vagrant I then click Test Connection, and get told the specified user/password combination is rejected: [28000][1045] Access denied for user ''@'localhost' (using password: NO), so I put in root and no password, press ok, then get a Successfull test connection I then click on the Schemas tab, and make sure that magento and magento_integration_tests are both selected Go back to the General tab, click on Test Connection again (it works) Press OK

The databases window now has @localhost listed, but the only thing under that is the word Schemas....

I would be expecting to see magento and magento_integration_tests.

Can you at least update the README with some specific instructions on how to set up PHPStorm to connect to the database?

Thanksk

[paliarush]

Hi @luke-denton-aligent , Schemas.... was introduced in one of the latest versions of PhpStorm and was confusing to me at first too, just click on it and you will get the full list of available DBs. BTW, this topic is briefly covered by https://github.com/paliarush/magento2-vagrant-for-developers#connecting-to-mysql-db

Sorry for missing your message, posting answer just in case someone has similar question.