Mysql容器启动避坑指南

安装

docker run --name mysql-57 \
-v /root/mysql/data:/var/lib/mysql \
-p 51020:3306 \
-e MYSQL_DATABASE=sale  \
-e MYSQL_ROOT_PASSWORD=mypassword \
-d mysql:5.7

1. 宿主机挂载目录/root/mysql/data可以不存在,docker会自动创建宿主机目录,并复制容器内文件至宿主机.如果/root/mysql/data目录存在则最好保证为空目录.
2. 容器启动后不要马上进入登录mysql,可能mysql没启动完成会报错,稍等十几秒即可.

>>> docker exec -it  mysql-57  /bin/bash
root@74010ff61487:/>>> mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.28 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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.

mysql>