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.
2
Answers
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.I assume that you already know how to add new DB connection to
MySQL Workbench
orDBeaver
. 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
orDBeaver
connect to the URL of the MySQL node, which ismysql1
node in your example. As shown in your screen capture, it is192.168.0.10
without any explicit port. But if you have troubles with the URL, you can rundocker ps
to check what host and port that yourmysql1
is running and exposed at.For the username/password: root/tpffnrtm1 (the password is the value of
MYSQL_ROOT_PASSWORD
as shown in yourdocker 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).