How to connect mysql on windows via Navicat?

Question

How to connect mysql on windows via Navicat?

minhluan259 opened this issue 8 years ago · 5 comments

Answer 1 · 2016-03-11T18:04:51.000Z

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.

Answer 2 · 2016-03-11T18:10:48.000Z

@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.

Answer 3 · 2016-03-12T00:01:34.000Z

Thank you. I have connect success with config:

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

Answer 4 · 2016-08-06T13:54:49.000Z

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

Answer 5 · 2016-08-08T03:47:45.000Z

@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