haoxy/mysql repository overview

docker pull haoxy/mysql

[root@bogon ~]# docker images 
REPOSITORY                TAG                 IMAGE ID            CREATED             SIZE
hxy/mysql                 5.6                 a13c49e4455a        3 minutes ago       506MB

运行docker，并且绑定端口3306

docker run -d -p 3306:3306 hxy/mysql:5.6
第一次运行时一个admin 用户被创建，并且赋予所有的权限，和一个随机密码，通过下面的命令查看密码

  docker logs <CONTAINER_ID>

类似

[root@bogon ~]# docker logs 67d302dc6eb5
========================================================================
You can now connect to this MySQL Server using:
    mysql -uadmin -p2G0YfZRlA1wo -h<host> -P<port>
Please remember to change the above password as soon as possible!
MySQL user 'root' has no password but only allows local connections
========================================================================
tail -F $LOG

指定一个密码：

docker run -d -p 3307:3306 -e MYSQL_PASS="mypass" haoxy/mysql：5.6
mysql -uadmin -p"mypass"

在宿主机上安装mysql客户端（以CentOS 7 为例）

yum install mysql-server mysql-devel mysql
​
 mysql -uadmin -pmypass -h192.168.0.169 -P3307
说明：192.168.0.169 为宿主机的IP地址，3307 是宿主机映射给容器的地址