你是对的。问题是mysql.sock文件被放到了/var/lib/mysql中，而这个文件被挂载到了一个不支持Unix域套接字的Windows主机系统目录中。
启动服务器时只需使用开关--socket=/tmp/mysql.sock。

如果您需要此文件用于docker-compose，则可以使用以下docker-compose.yml和my.cnf文件。
在my.cnf文件中，套接字位置从socket=/var/lib/mysql/mysql.sock更改为socket=/tmp/mysql.sock。

停靠-撰写.yml

version: "3.7"
services:
  mysql:
    image: mysql/mysql-server:5.7.27
    volumes:
      - "./my.cnf:/etc/my.cnf"

我的.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
skip-host-cache
skip-name-resolve
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
secure-file-priv=/var/lib/mysql-files
user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

2022更新如果您希望使用Docker Hyper-V为Docker（Windows）MySQL创建持久数据库
1.在您希望存放DB数据的任何位置创建一个文件夹，例如D：\DockerDB
1.现在，在Hyper-v模式下使用Docker。
1.转到设置-〉资源-〉文件共享-〉添加您的DB数据文件夹在这里。（D：\DockerDB）和应用和重启。x1c 0d1x
在您的docker-compose.yml文件中，按如下方式添加卷

mysqldb:
    container_name: mysqldb
    image: mysql
    volumes:
      - D:/DockerDB:/var/lib/mysql

现在，您的数据将保存在本地机器的DB中。