How to connect mysql on windows via Navicat?

[minhluan259]

[paliarush]

As far as I know, all MySQL clients are able to create SSH tunnel, here is dedicated docs page for Navicat.

To get ssh credentials, navigate to project root folder (that which contains "Vagrantfile") and execute vagrant ssh-config. There you should see HostName (127.0.0.1), Port (custom for your installation), User (vagrant) and IdentityFile (custom path to SSH private key). It should also be possible to use vagrant password instead of private key.

[paliarush]

@minhluan259 will you be able to contribute PR with corresponding section to the readme? It would help other guys who might have the same question. Just avoid Navicat-specific guidance.

[minhluan259]

Thank you. I have connect success with config:

Port from config.yam : 3192 (forwarded_ssh_port)
Username/password: vagrant/vagrant

[refaelgold]

There is an option to connect to mysql via IDE like phpstorm?

[paliarush]

@refaelgold sure, I personally use PhpStorm to connect to DB (via SSH tunnel), see https://confluence.jetbrains.com/display/PhpStorm/Databases+and+SQL+Editor+in+PhpStorm#DatabasesandSQLEditorinPhpStorm-Settingupadatabaseconnection