Skip to content

Instantly share code, notes, and snippets.

@joannaong

joannaong/vagrant-mySQLWorkbench.md

Last active August 13, 2018 12:20
Show Gist options
  • Save joannaong/3ea246bda8c02ad010f1d2977fb8bb58 to your computer and use it in GitHub Desktop.
Save joannaong/3ea246bda8c02ad010f1d2977fb8bb58 to your computer and use it in GitHub Desktop.
Download ZIP
vagrant-mySQLWorkbench
Raw
vagrant-mySQLWorkbench.md

Step-by-step guide @http://www.bentedder.com/using-mysql-workbench-with-vagrant/

Download (if you don't have it) MySQL Workbench

  • Within your project directory type vagrant ssh-config in the command line.
  • This will give you a few things you'll need.
User: (most likely vagrant)
IdentityFile (the path to the private key that MySQL workbench will need)

Open up MySQL Workbench and create a new connection

  • Connection Method: Standard TCIP/IP over SSH
  • SSH Hostname: 127.0.0.1:2222
  • SSH Username: vagrant (from your ssh-config above)
  • SSH Password: leave this alone
  • SSH Key File: Use the IdentityFile path from above. I tried copy/pasting it, but found that I had to actually browse to the file for it to work correctly. Probably user error.
  • MySQL Hostname: 127.0.0.1
  • MySQL Port: 3306
  • Username: whatever username you usually use
  • Password: the password for the db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment