linux docker安装mysql

深碍√TFBOYSˉ_ 2021-10-18 18:46 218阅读 0赞

Linux 中使用Docker 安装mysql

### 步骤 ###

**下载mysql镜像**

docker pull mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0RyZWFtX3h1bg_size_16_color_FFFFFF_t_70][]

**创建mysql容器并启动**

docker run -d --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 ed1ffcb5eff3(mysql镜像ID)

命令说明：

*  **-p 3306:3306：**将容器的3306端口映射到主机的3306端口
 *  **-e MYSQL\_ROOT\_PASSWORD=123456：**初始化root用户的密码
 *  **-d:** 后台运行容器，并返回容器ID
 *  **imageID: **mysql镜像ID

**进入mysql容器：**

docker exec -it mysql bash

![20200112215853864.png][]

**登陆mysql:**

ps:密码为创建容器时设置的密码

root@07cc12a93c09:/# mysql -uroot -p

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0RyZWFtX3h1bg_size_16_color_FFFFFF_t_70 1][]

**添加远程登录用户**

CREATE USER 'root'@'%' IDENTIFIED WITH mysql\_native\_password BY '123456';

**授予权限**

GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%';

### **注意：如果使用navicat连接数据库报错1251请参考下边这篇文章：** ###

[https://blog.csdn.net/a15123837995/article/details/83751612][https_blog.csdn.net_a15123837995_article_details_83751612]

### 脱坑参考原文地址： ###

[https://www.cnblogs.com/lonelyxmas/p/10584886.html（第二次安装参考的文章）][https_www.cnblogs.com_lonelyxmas_p_10584886.html]

[https://www.cnblogs.com/xfk1999/p/11328955.html][https_www.cnblogs.com_xfk1999_p_11328955.html]

[https://www.runoob.com/docker/docker-install-mysql.html][https_www.runoob.com_docker_docker-install-mysql.html]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0RyZWFtX3h1bg_size_16_color_FFFFFF_t_70]: /images/20211018/050463c92c2f453f956870966ef4d128.png
[20200112215853864.png]: /images/20211018/a8501318a64e4dc397dba325beddea48.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0RyZWFtX3h1bg_size_16_color_FFFFFF_t_70 1]: /images/20211018/c39c34f676a149c9b6f412f1aea5c650.png
[https_blog.csdn.net_a15123837995_article_details_83751612]: https://blog.csdn.net/a15123837995/article/details/83751612
[https_www.cnblogs.com_lonelyxmas_p_10584886.html]: https://www.cnblogs.com/lonelyxmas/p/10584886.html
[https_www.cnblogs.com_xfk1999_p_11328955.html]: https://www.cnblogs.com/xfk1999/p/11328955.html
[https_www.runoob.com_docker_docker-install-mysql.html]: https://www.runoob.com/docker/docker-install-mysql.html