拉去镜像
docker pull mysql:5.7
查看镜像
docker images
结果：
[root@VM_0_2_centos conf]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
mysql 5.7 84164b03fa2e 3 weeks ago 456MB
[root@VM_0_2_centos conf]#
创建mysql的映射目录
mkdir -p /usr/local/mysql/data /usr/local/mysql/logs /usr/local/mysql/conf
创建配置文件
cd /usr/local/mysql/conf && touch my.cnf
启动容器 并映射刚创建的目录、设置root密码为123456
docker run -p 3306:3306 --name mysql -v /usr/local/mysql/conf:/etc/mysql/conf.d -v /usr/local/mysql/logs:/logs -v /usr/local/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
执行结果：
[root@VM_0_2_centos conf]# docker run -p 3306:3306 --name mysql -v /usr/local/mysql/conf:/etc/mysql/conf.d -v /usr/local/mysql/logs:/logs -v /usr/local/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
d9fe468f1d89546ada1f0436bca022458418fba4c5061593ac1fb135e6490957
[root@VM_0_2_centos conf]#
启动mysql
docker start mysql
查看mysql容器
[root@VM_0_2_centos /]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
d9fe468f1d89 mysql:5.7 "docker-entrypoint.s…" 51 minutes ago Up 7 minutes 0.0.0.0:3306->3306/tcp, 33060/tcp mysql
[root@VM_0_2_centos /]#
进入mysql容器内部
docker exec -ti d9fe468f1d89 /bin/bash
登陆mysql
mysql -u root -p
修改root 可以通过任何客户端连接
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
使用客户端测试
image.png
说明
本文只做学习参考，如有任何不准确的地方欢迎指正。
我的邮箱：
lulongji2011@163.com
