How to connect to a Docker container running mysql on Windows 10

Question

I cannot figure out how to connect to my container from the host. I have tried localhost and 127.0.0.1. But I get an error like this:

/* Connecting to 127.0.0.1 via MySQL (TCP/IP), username root, using password: Yes ... */
/* Can't connect to MySQL server on '127.0.0.1' (10061) */

docker ps I get the following:

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS               NAMES
300248b56399        mysql:5.6           "docker-entrypoint.sh"   About an hour ago   Up About an hour    3306/tcp            memories

Answer 1

This is simple, just publish port 3306

docker run -p 3306:3306 --name memories -e MYSQL_ROOT_PASSWORD=password -d mysql:5.6

Answer 2

This shouldn'be very difficult, follow these steps:

Start => services => MySQL(ver) => Right-Click => Start

Answer 3

I got the exact same error. I hadn't started the MySQL server.

Answer 4

From my experience, start your XAMPP server and then start your MySQL server.

Answer 5

In my case, I hadn't installed the mysql server itself. I installed it and the error disappeared.

Answer 6

Follow these steps:
run MySQLInstanceConfig.exe
C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\MySQLInstanceConfig.exe
Follow until the end without changing anything.

Answer 7

Avoid using bind_address in your my.cnf file. I don't know why but this helped me! If somebody knows the reason why, do let me know. Thank you!