How Do I Connect to a MySQL Docker Container from My Host Machine?

Connecting to MySQL in Docker Container from Host

When attempting to connect to a MySQL instance running within a Docker container from the host machine, you may encounter the error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

To resolve this issue and connect successfully, follow these steps:

1. Specify the host address, port, and protocol when connecting from the host:

mysql -h localhost -P <port> --protocol=tcp -u root

Replace with the port you have forwarded from the Docker container (e.g., 12345).

2. MySQL in Docker containers runs on TCP, not sockets. Using --protocol=tcp specifies TCP connection.
3. Ensure that the bind-address in the MySQL configuration within the Docker container is set to '0.0.0.0' to allow connections from outside the container.

With these modifications, you should be able to successfully connect to the MySQL instance in the Docker container from your host machine. Remember to replace localhost in the connection command with the IP address or hostname of the host machine.

The above is the detailed content of How Do I Connect to a MySQL Docker Container from My Host Machine?. For more information, please follow other related articles on the PHP Chinese website!