How to access mysql database on Vagrant from the host OS using MySQL Workbench.

Then the following options worked for me in MySQL Workbench:

Connection Method: Standard TCP/IP over SSH
SSH Hostname: 127.0.0.1:2222
SSH Key File: ~/.vagrant.d/insecure_private_key
Mysql Hostname: 127.0.0.1
Mysql Server Port: 3306
Username: root
Password:

You may need to adjust some of the settings if your setup is different.

Comments

Solved it for me. Thanks Mr.

Solved it for me. Thanks Mr. Pajdzik!

Post new comment

  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <iframe> <embed> <object> <img>
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • Lines and paragraphs break automatically.

More information about formatting options