Cannot connect to MySQL

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 Key: Select the following file from your Trellis directory: .vagrant/machines/default/virtualbox/private_key


(alternate)
Connection type: SSH
MySQL host: 127.0.0.1
Username: example_dev (use the value of DB_USER from site/.env)
Password: devpw (use the value of env: db_password from group_vars/development/vault.yml)
SSH Host: example.dev
SSH User: vagrant
SSH Key: Select the following file from your Trellis directory: .vagrant/machines/default/virtualbox/private_key



SETUP SEQUEL PRO REMOTE
-----------------------

(from documentation)
Connection type: SSH
MySQL host: 127.0.0.1
Username: root
Password: productionpw (use the value of vault_mysql_root_password from group_vars/<environment>/vault.yml)
SSH Host: example.com
SSH User: web


(alternate)
Connection type: SSH
MySQL host: 127.0.0.1
Username: example_dev (use the value of DB_USER from site/.env)
Password: productionpw (use the value of env: db_password from group_vars/<environment>/vault.yml)
SSH Host: example.com
SSH User: web
1 Like