How to set up connection to remote MySQL in PhpStorm (via Vagrant)?

Question

MySQL

I have Ubuntu.
It has a CentOS virtual machine installed via the VirtualBox + Vagrant bundle.
MySQL is installed in this virtual machine, there is a trop database and a user with rights to it.
When I try to connect to the specified database, I get an error message:
Exception creating connection to: localhost; nested exception is: java.net.NoRouteToHostException
: No route to host

Answer 1

localhost is the machine you are working on.
You also need to specify the network address of the virtual machine.
Most likely, access to the database from the outside is closed by default - you will need to allow it.

Answer 2

Vagrant by default (or manually) has port forwarding for SSH (localhost:2222). When creating a database connection, specify that you need to work through SSH using the key (in the .vagrant/*/private_key folder). Next, configure the connection itself through localhost (this will already be a virtual machine).