MySQL connection options with defaults for Vagrant/Azure?

[eavonius]

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.

[kalenjohnson]

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?

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

Sequel pro + ssh to vagrant

What is the basic setup for sequel pro connecting to vagrant? I had it working but now (with SSL certs added) I can't seem to connect to a site I previously was able to connect to. Setup in Sequel Pro mysql host: 127.0.0.1 user: root pass: root ssh host: mysite.dev ssh user: vagrant ssh pass: vagrant Error in Sequel Pro is Permission denied (publickey). but keys are added on vagrant up. Also have done several provisions and destroy/up. This was working previously, sigh.

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