Accessing Dev Desktop databases with Sequel Pro

Accessing Dev Desktop databases with Sequel Pro

2 posts / 0 new
Last post
paul_14's picture
paul
Points: 0
Accessing Dev Desktop databases with Sequel Pro

Hi,
I've just started using Dev Desktop. It works fine (and I love it), but I'd like to use Sequel Pro to manage the MySql databases. Unfortunately, I can't get a connection to work.

I've found some articles which talk about setting up a socket connection using mysql.sock, but I cannot find this file anywhere.
Can someone help me please as this is driving me nuts!

Cheers,

Paul Drake

Status: 
Resolved (feature request)
yuan.xie's picture
yuan.xie
Points: 30

Documentation is here: https://docs.acquia.com/articles/remote-database-administration-using-th...

Please also see the screenshot for a proper connection setup to Acquia Cloud including free tier.

Make sure your ssh keys are set correctly.

One catch here is that you will need to use "localhost" as the MySql Host. Sequel Pro tries to be smart and make you use 127.0.0.1 instead of "localhost", which then unfortunately will not work with Acquia Cloud. The workaround here is to add a space after "localhost" (again, see screenshot).

Status Change: 
Resolved