# MySQL connection options with defaults for Vagrant/Azure?

**URL:** https://discourse.roots.io/t/mysql-connection-options-with-defaults-for-vagrant-azure/4805
**Category:** trellis
**Created:** 2015-09-21T17:44:34Z
**Posts:** 2

## Post 1 by @eavonius — 2015-09-21T17:44:34Z

I’ve added a forwarded port in vagrant so I can hit MySQL:

config.vm.network :forwarded\_port, guest: 3306, host: 3306

with this set, what credentials can I use with a default trellis VM setup (username and password)?

Also, I’ve got my prod VM on Azure that I used trellis to deploy to. If I want to hit it without making a bunch of tweaks to the server, can I just open port 3306 or do I need to use SSH?

I’m using SQL workbench and there’s an option to use SSH, but it has a field for username and password in addition to the SSH key to use which is confusing since my VM in the cloud doesn’t allow a password, only SSH.

Any tips would be appreciated.

Thanks.

---

## Post 2 by @kalenjohnson — 2015-09-21T17:54:54Z

Please do a search before posting a question. Using a GUI to interact with the database has been covered multiple times:

> [@How to setup DB on bedrock-ansible?](https://discourse.roots.io/t/how-to-setup-db-on-bedrock-ansible/3461/9):
>
> Figured it out in case others have this issue: mysql host: 127.0.0.1 user: user pw: password ssh host: 127.0.0.1 ssh user: vagrant ssh password: vagrant

[https://discourse.roots.io/t/sequel-pro-ssh-to-vagrant/4683](https://discourse.roots.io/t/sequel-pro-ssh-to-vagrant/4683)

If you can SSH to the server, that will probably be better and easier than opening the MySQL port.