I’m unable to connect to MySQL using the value of vault_mysql_root_password in group_vars/production/vault.yml I am able to deploy and provision the server without any errors. Trying to connect to the remote database using Sequel Pro and following the instructions here: https://roots.io/trellis/do…

[image] Sequel pro + ssh to vagrant trellis root will no longer work, I’ve updated the docs to reflect this

Did you read through this whole thread? The reply linked has a screenshot of working settings. [image] Sequel pro + ssh to vagrant trellis Got to working on Windows 10 and MySQL Workbench. Use your vault_mysql_root_password located in your \group_vars\development\vault.y…

Hi guys, I have this issue also and I’m trying to track down where it has come from. It appears to be present since the mariaDB source was changed in ansible here: https://github.com/roots/trellis/commit/f7873ec29f7544b20255e05aaadd18403b98307b It appears there is an issue with the plugin unix_soc…

yeah, also have the exact same setup running on an older version of trellis without any issues.

i’m not having this issue locally, only on the remote server.

This can also be carried out on your live server too. When mysql is installed on Ubuntu 15+ it prefers the unix_socket plugin for mysql root login (i.e. you can only log in as root for mysql with a sudo account). This problem only came to light on my local environment as our database is held with RD…

Seems to be more of a security thing than anything else. With the latest version of Trellis as @craigpearson had said above vagrant ssh then mysql -u root -p fails, but sudo mysql -u root -p works fine, you just hit enter when prompted for password because the sudo password for vagrant user is blan…

Hey @RiFi2k The alternative worked fine for me with the MySQL Workbench! Thanks for this! [image] Sequel pro + ssh to vagrant trellis Hey @cclass Here is an alternative to connect to DB that I got to working on the production server: [image] The MySQL password is loc…

Yes. This worked for me too. SETUP SEQUEL PRO LOCAL ---------------------- (from documentation) Connection type: SSH MySQL host: 127.0.0.1 Username: root Password: devpw (use the value of vault_mysql_root_password from group_vars/development/vault.yml) SSH Host: example.dev SSH User: vagrant SSH K…

Cannot connect to MySQL

trellis

gabrielgiordan December 18, 2016, 10:38pm 8

Hey @RiFi2k

The alternative worked fine for me with the MySQL Workbench! Thanks for this!