Docker安装MySQL8.0

System: CentOS7
Docker Version: 20.10.16
Docker API Version: 1.41

Docker安装MySQL8.0, 设置远程访问, 并挂载数据到本地

1. 拉取镜像

<span class="token function">docker</span> pull mysql 
<span class="token function">docker</span> pull mysql 
docker pull mysql 

2. 创建并运行容器

 <span class="token function">docker</span> run <span class="token parameter variable">--name</span> <span class="token punctuation">[</span>mysql-name<span class="token punctuation">]</span> <span class="token parameter variable">-v</span> <span class="token punctuation">[</span>/app/mysql/data<span class="token punctuation">]</span>:/var/lib/mysql <span class="token parameter variable">-e</span> <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span><span class="token punctuation">[</span>password<span class="token punctuation">]</span> <span class="token parameter variable">-p</span> <span class="token punctuation">[</span><span class="token number">3308</span><span class="token punctuation">]</span>:3306 <span class="token parameter variable">-d</span> mysql --character-set-server<span class="token operator">=</span>utf8mb4         <span class="token function">docker</span> run <span class="token parameter variable">--name</span> xmysql <span class="token parameter variable">-v</span> /app/mysql/data:/var/lib/mysql <span class="token parameter variable">-e</span> <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mysql.admin <span class="token parameter variable">-p</span> <span class="token number">3308</span>:3306 <span class="token parameter variable">-d</span> mysql --character-set-server<span class="token operator">=</span>utf8mb4 
 <span class="token function">docker</span> run <span class="token parameter variable">--name</span> <span class="token punctuation">[</span>mysql-name<span class="token punctuation">]</span> <span class="token parameter variable">-v</span> <span class="token punctuation">[</span>/app/mysql/data<span class="token punctuation">]</span>:/var/lib/mysql <span class="token parameter variable">-e</span> <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span><span class="token punctuation">[</span>password<span class="token punctuation">]</span> <span class="token parameter variable">-p</span> <span class="token punctuation">[</span><span class="token number">3308</span><span class="token punctuation">]</span>:3306 <span class="token parameter variable">-d</span> mysql --character-set-server<span class="token operator">=</span>utf8mb4         <span class="token function">docker</span> run <span class="token parameter variable">--name</span> xmysql <span class="token parameter variable">-v</span> /app/mysql/data:/var/lib/mysql <span class="token parameter variable">-e</span> <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mysql.admin <span class="token parameter variable">-p</span> <span class="token number">3308</span>:3306 <span class="token parameter variable">-d</span> mysql --character-set-server<span class="token operator">=</span>utf8mb4 
 docker run --name [mysql-name] -v [/app/mysql/data]:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=[password] -p [3308]:3306 -d mysql --character-set-server=utf8mb4         docker run --name xmysql -v /app/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=mysql.admin -p 3308:3306 -d mysql --character-set-server=utf8mb4 

3. 设置允许远程连接

打开容器交互模式(容器名称或者ID根据实际情况填写)

<span class="token function">docker</span> <span class="token builtin class-name">exec</span> <span class="token parameter variable">-it</span> xmysql <span class="token function">bash</span> 
<span class="token function">docker</span> <span class="token builtin class-name">exec</span> <span class="token parameter variable">-it</span> xmysql <span class="token function">bash</span> 
docker exec -it xmysql bash 

登录MySQL

mysql <span class="token parameter variable">-u</span> root <span class="token parameter variable">-p</span> 
mysql <span class="token parameter variable">-u</span> root <span class="token parameter variable">-p</span> 
mysql -u root -p 

添加远程登录用户(用户名密码可自定义)

CREATE <span class="token environment constant">USER</span> <span class="token string">'admin'</span>@<span class="token string">'%'</span> IDENTIFIED WITH mysql_native_password BY <span class="token string">'password'</span><span class="token punctuation">;</span> 
CREATE <span class="token environment constant">USER</span> <span class="token string">'admin'</span>@<span class="token string">'%'</span> IDENTIFIED WITH mysql_native_password BY <span class="token string">'password'</span><span class="token punctuation">;</span> 
CREATE USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; 

给新建用户赋予权限

GRANT ALL PRIVILEGES ON *.* TO <span class="token string">'admin'</span>@<span class="token string">'%'</span><span class="token punctuation">;</span> 
GRANT ALL PRIVILEGES ON *.* TO <span class="token string">'admin'</span>@<span class="token string">'%'</span><span class="token punctuation">;</span> 
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%'; 

刷新

flush privileges<span class="token punctuation">;</span> 
flush privileges<span class="token punctuation">;</span> 
flush privileges; 

4. 连接可视化客户端

原文链接：https://blog.csdn.net/VXadmin/article/details/128252911?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522168994674516800182116245%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=168994674516800182116245&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_ecpm_v1~times_rank-5-128252911-null-null.268%5Ev1%5Ekoosearch&utm_term=docker%E3%80%81wordpress%E3%80%81wordpress%E5%BB%BA%E7%AB%99%E3%80%81wordpress%E4%B8%BB%E9%A2%98%E3%80%81%E5%AE%B9%E5%99%A8%E9%95%9C%E5%83%8F%E3%80%81