Error connecting Docker MySQL DB through Workbench

[miu]

Hello All,

I have a project running on NodJS + Docker + MySQL.
The Development DB is in Docker.

While trying to connect to the DB using Workbench, I am getting below error.

These are the settings I am using connecting Workbench. I ma using the Root User Password from the Targets setting.

Can you help me in getting around this error?

[Cheese]

Think we are going to see a lot of this moving forwards, AI help that is. Try the below courtesy of, yes you guessed it, ChatGPT!

If you're using MySQL Workbench to connect to a MySQL database running inside a Docker container, follow these steps:

1. Ensure the MySQL Container is Running

First, make sure your MySQL container is running. You can check this by using the following command:

bash

Copy code

docker ps

Look for the container that has MySQL running, and verify the port mapping (it should map port 3306 inside the container to port 3306 on your host machine).

2. Get the Connection Details

• Host: If you're running the container on the same machine as MySQL Workbench, you can use localhost or 127.0.0.1 as the host.
• Port: Make sure you map the MySQL port from the container to the host. By default, MySQL uses port 3306. You can verify the port mapping when you start the container with the -p flag (e.g., -p 3306:3306). If you're unsure, you can check the port mapping using:

bash

Copy code

docker port mysql-container

This should output something like:

bash

Copy code

3306/tcp -> 0.0.0.0:3306

• Username: This will be the MySQL user. If you haven't created any other users, the default is root.
• Password: This is the password you set when creating the container. For example, if you ran docker run -e MYSQL_ROOT_PASSWORD=my-secret-pw, then the password is my-secret-pw.

3. Configure MySQL Workbench

Now, configure MySQL Workbench with the following steps:

1. Open MySQL Workbench and click on the + button next to MySQL Connections to create a new connection.
2. Connection Name: Give it a name (e.g., Docker MySQL).
3. Connection Method: Select Standard (TCP/IP).
4. Hostname: Enter 127.0.0.1 or localhost (the IP of your host machine running Docker).
5. Port: Enter 3306 (or whatever port you mapped to the container's MySQL port).
6. Username: Enter root (or another MySQL user if you created one).
7. Password: Click on the Store in Vault... button and enter the root password you set when creating the container (e.g., my-secret-pw).
8. Test Connection: After filling out all fields, click Test Connection to ensure that MySQL Workbench can connect to the database. If the test is successful, you should see a message like "Successfully made the MySQL connection."
9. Save the Connection: Once the connection is working, click OK to save the connection.

4. Access Your MySQL Database

After saving the connection, double-click on it to connect to the MySQL database. You should now be able to run queries, browse databases, and manage your MySQL instance from MySQL Workbench.

Troubleshooting Tips:

• Connection issues: If you're unable to connect, double-check that your Docker container is running and that port 3306 is properly exposed to your host machine.
• Firewall: If you’re running Docker on a remote machine or VM, ensure that your firewall allows inbound traffic on port 3306.
• Correct Password: Make sure the password you’re entering in MySQL Workbench matches the one you set in the Docker container.

[miu]

Thanks @Cheese , i will give this a try and see if I can connect to the DB.

[Hyperbytes]

Just tried with these settings and connects OK

Perhaps something is missing from your Workbench installation

[Hyperbytes]

Are you on workbench 8.0.40? May be an issue with that version#

https://forums.mysql.com/read.php?152,727710,727759

[miu]

Thanks @Hyperbytes, the issue was indeed with the Workbench 8.0.40.
I installed 8.0.38 and it connected with my DB.

Thanks @Cheese for your help as well.