无法连接到MySQL 5.7运行作为docker容器从docker主机使用mysql客户端

Question

在浏览了SOF的以下链接后，我仍然面临着这个问题，没有任何推理或解决方案。

参考资料：

• 连接到mysql docker容器

Mysql 5.7在我的本地计算机中作为容器运行。服务器启动后，使用root用户或创建的新用户连接到服务器时，会在localhost/0.0.0/127.0.0.1上发生故障。即使在禁用firewald之后，连接也会失败，并出现相同的错误。我可能对这种连接做了一些非常错误的事情。任何建议都会有帮助。

version: '3.5'
services:
  service:
    image: mysql:5.7
    #build:
    #  context: ./
    #  dockerfile: Dockerfile
    environment:
      MYSQL_USER: user
      MYSQL_PASSWORD: manage
      MYSQL_ROOT_PASSWORD: manage
      MYSQL_DATABASE: testapp
    ports:
      - published: 3306
        target: 3306

下面是docker compose up-d之后的输出

docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                               NAMES
45ba02e6e457        mysql:5.7           "docker-entrypoint.s…"   52 seconds ago      Up 50 seconds       0.0.0.0:3306->3306/tcp, 33060/tcp   

下面是连接到mysql容器的尝试。

mysql -u root -h localhost -pmanage
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

mysql -u root -h 0.0.0.0 -pmanage
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

mysql -u root -h 127.0.0.1 -pmanage
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

运行容器的IP工作正常。但这并不是一个解决方案，因为IP会随着时间而变化。

mysql -u root -h 172.31.0.2 -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.30 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

我不是在寻找另一个docker命令的解决方案。如何连接到mysql容器从docker主机使用mysql客户端。

Answer 1

您需要在连接url中使用--protocol=tcp。

mysql -u root -h localhost --protocol=tcp

您的mysql正在docker容器中运行。因此，您必须通过TCP进行连接，而本地套接字对此不可用。这基本上是这个问题的重复。