搜索 MySQL 镜像
docker 官网：https://hub.docker.com/_/mysql
下载 MySQL 镜像
默认最新版本
运行 MySQL 容器
1 2 3 4 5 6 docker run -p 3306:3306 --name mysql \ -v /usr/local /docker/mysql/conf:/etc/mysql/conf.d/ \ -v /usr/local /docker/mysql/logs:/var/log /mysql \ -v /usr/local /docker/mysql/data:/var/lib/mysql \ -e MYSQL_ROOT_PASSWORD=123456 \ -d mysql
命令参数：
-p 3306:3306：将容器的3306端口映射到主机的3306端口-v /usr/local/docker/mysql/conf:/etc/mysql/conf.d/：将主机当前目录下的 conf 挂载到容器的 /etc/mysql/conf.d/-v /usr/local/docker/mysql/logs:/var/log/mysql：将主机当前目录下的 logs 目录挂载到容器的 /var/log/mysql-v /usr/local/docker/mysql/data:/var/lib/mysql：将主机当前目录下的 data 目录挂载到容器的 /var/lib/mysql-e MYSQL_ROOT_PASSWORD=123456：初始化 root 用户的密码
查看容器是否运行
进入 MySQL 容器
1 docker exec -it mysql bash
在容器内登陆 MySQL
查看用户信息并赋予访问权限
1 select host,user ,plugin,authentication_string from mysql.user;
结果：
1 2 3 4 5 6 7 8 9 10 11 12 13 mysql> select host,user,plugin,authentication_string from mysql.user; +-----------+ ------------------+-----------------------+ ------------------------------------------------------------------------+| host | user | plugin | authentication_string | +-----------+ ------------------+-----------------------+ ------------------------------------------------------------------------+| % | root | caching_sha2_password | $A$005$f+WN\N>cQO#;SqoIG3n5hmq/r6LF5EV2/O4lp5VMw3JQXQfz6DzHeqWV0 | | localhost | mysql.infoschema | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | mysql.session | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | mysql.sys | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | root | caching_sha2_password | $A$005$I T9Cz| VE\ 9AXGgVLqIOitU4MzwycwC/jRXmroU2M.pObTLs9T5tz7 | +-----------+ ------------------+-----------------------+ ------------------------------------------------------------------------+5 rows in set (0.00 sec)
备注：
host 为 % 表示不限制 iplocalhost 表示本机使用plugin 非 mysql_native_password 则需要修改密码
1 2 3 ALTER user 'root' @'%' IDENTIFIED WITH mysql_native_password BY '123456' ;FLUSH PRIVILEGES;
再次查询：
1 2 3 4 5 6 7 8 9 10 11 12 13 mysql> select host,user,plugin,authentication_string from mysql.user; +-----------+ ------------------+-----------------------+ ------------------------------------------------------------------------+| host | user | plugin | authentication_string | +-----------+ ------------------+-----------------------+ ------------------------------------------------------------------------+| % | root | mysql_native_password | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | localhost | mysql.infoschema | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | mysql.session | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | mysql.sys | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | root | caching_sha2_password | $A$005$I T9Cz| VE\ 9AXGgVLqIOitU4MzwycwC/jRXmroU2M.pObTLs9T5tz7 | +-----------+ ------------------+-----------------------+ ------------------------------------------------------------------------+5 rows in set (0.01 sec)
最后退出：
If you like this blog or find it useful for you, you are welcome to comment on it. You are also welcome to share this blog, so that more people can participate in it. If the images used in the blog infringe your copyright, please contact the author to delete them. Thank you !