connect to mysql via SQLYog

[karolisbarkauskas]

Hello,
how can I connect to this WM via sqlYog or HeidiSQL?

Awesome job, looking forward for your answer !

[Das123]

This question is a bit old and I also needed to solve this. I found the answer here although it didn't relate specifically to SQLYog... https://gielberkers.com/how-to-connect-to-mysql-in-vagrant-from-your-host-machine/

To do this in SQLYog using default ports from r8:
File --> New Connection
New [Name of Connection]

MySQL Tab:
MySQL Host Address: 127.0.0.1
Username: root
Password: vagrant
Port: 3306

SSH Tab:
Check Use SSH Tunneling
SSH Host Address: 127.0.0.1
Username: vagrant
SSH Port: 2222
Password: vagrant

Test Connection
Connect
Profit. :)

I guess the ports would need to be changed if you amend the Vagrantfile settings.

[plindsay]

hi there, I get an error in Sequel Pro when I try to connect to MySQL - here is a screenshot -

Can anyone help? Bit stuck!

Thanks