How to connect to MySQL database cluster

Question

I tried to install a MySQL cluster with the Docker image below.

mysql/mysql-cluster - Docker Image | Docker Hub

The Docker image is pulled and run successfully.

Despite that I could connect to the cluster in the terminal (as shown in the screen capture below), I don't know how to connect to it with MySQL Workbench or DBeaver.

Answer 1

In your docker run command, you can use -p 3306:3306 (or any available port). Then you can use <host>:<port> from Workbench or Dbeaver connection URL.

Answer 2

I assume that you already know how to add new DB connection to MySQL Workbench or DBeaver. The information that you want is the connection URL and the username/password of an authenticated user that you need to use to connect to your MySQL cluster.

For the connection URL: 192.168.0.10 (no port in your example)

You need to have your MySQL Workbench or DBeaver connect to the URL of the MySQL node, which is mysql1 node in your example. As shown in your screen capture, it is 192.168.0.10 without any explicit port. But if you have troubles with the URL, you can run docker ps to check what host and port that your mysql1 is running and exposed at.

For the username/password: root/tpffnrtm1 (the password is the value of MYSQL_ROOT_PASSWORD as shown in your docker run of MySQL node command)

I assume that you just want to connect the DB cluster by any means (root or non-root privileges is totally fine for you).