[SOLVED] EEv4 + macOS Mojave and managing DB from SequelPro or TablePlus

[locke]

I have to insist in this topic ,because I don’t and can’t find the answer.

I don’t really know what to do locally:

I get the MySQL Pass:

cat ~/easyengine/services/docker-compose.yml | grep MYSQL_ROOT_PASSWORD

I get the local IP:

docker inspect services_global-db- | grep IPAddress

I change the MDB permissions inside mysql -u root -p the Container

what I’m missing??

[bowefrankema]

Have you followed the guide here?

How to connect to MariaDB thru external app like Sequel Pro?

I do not use phpMyadmin to manage DB. Using a native application like SequelPro is a much better solution. If at the start of the container its IP address changes, it is impossible to save the connection parameters in the external application. How can I forward a connection to the database through the primary host?

It works fine for me…

Make sure to use the command.

docker inspect services_global-db_1 | grep IPAddress

And connect via SSH. I’ve attached a screenshot of my Sequel Pro.

[locke]

Ok guys, finally : This is what I needed to do to make work Sequel Pro or any other client with Local EasyEngine , like for example Brew easyengine local test environment.

to the mysql docker-compose.yml I needed to add the port:

global-db:
    image: easyengine/mariadb:v4.0.0
    ports:
     - "3306:3306"

Restart your Docker containers and that give the bind address ready:

And thats it, now you can go to your MySQL Workbench, SequelPro, TablePlus: