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: vag…

Thanks for all of the replies and info in this thread. I went ahead and added a doc on the site that covers how to connect to your databases (both local and remote): [image] Database Access | Trellis Documentation | Roots Accessing your WordPress databases in Trellis with Sequel Pro or My…

I use the hostname instead of the ip adress for the SSH Host, as your hostname is declared in your /etc/host file. [image]

Got to working on Windows 10 and MySQL Workbench. Use your vault_mysql_root_password located in your \group_vars\development\vault.yml for the MySQL Password Here are the other configurations: [image]

Thanks for the documentation. Wrote about accessing the database in Trellis locally with Sequel Pro here myself a while ago. Shouldn’t the documentation also mention port 2222 for local access?

It’s not necessary when you use the hostname of the box directly (example.dev) instead of 127.0.0.1.

Did not know that. Thanks for telling me @ben .

Hey guys, please, if I set sshd_permit_root_login: false how can I connect to the remote and local database? I’m trying here but no success whatsoever. I’ve figure out how to connect into the mysql using the ssh admin user and the vault_users password located into the group_vars/production/vault.ym…

did you figure this out? with sshd_permit_root_login set to false, i can ssh into the remote server with the admin user, but cannot connect to mysql – Access denied for user 'admin'@'localhost'. if i allow root login, i can ssh as root and connect to mysql just fine. however in Sequel Pro, i am u…

Hey @cclass Unfortunately I did not figure this out yet, for now I reenabled sshd_permit_root_login and I’m working with this. Soon I will try again, maybe SSH into it and creating a single user only for connecting to MariaDB or changing user DB permissions

Hey, @gabrielgiordan and @cclass , did you try my solution mentioned here: Cannot connect to MySQL

Sequel pro + ssh to vagrant

trellis

ben December 30, 2016, 7:35pm 61

root will no longer work, I’ve updated the docs to reflect this

Cannot connect to MySQL