# Cannot connect to MySQL

**URL:** https://discourse.roots.io/t/cannot-connect-to-mysql/8318
**Category:** trellis
**Created:** 2016-12-14T13:31:41Z
**Posts:** 10
**Showing post:** 9 of 10

## Post 9 by @ericgauvin — 2016-12-29T21:01:23Z

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
```

---

_[View the full topic](https://discourse.roots.io/t/cannot-connect-to-mysql/8318)._