search

r8 / vagrant-lamp

My default LAMP development stack for Vagrant
http://r8.github.io/vagrant-lamp/
753 stars 255 forks source link

connect to mysql via SQLYog #133

Open karolisbarkauskas opened 8 years ago

karolisbarkauskas commented 8 years ago

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

Awesome job, looking forward for your answer !

Das123 commented 8 years ago

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 commented 8 years ago

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

screenshot 2016-09-08 18 28 46

Can anyone help? Bit stuck!

Thanks