docker安装mysql

最新推荐文章于 2025-03-27 11:50:04 发布

转载最新推荐文章于 2025-03-27 11:50:04 发布 · 86 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://blog.youkuaiyun.com/qq_36814756/article/details/85250974

文章标签：

#mysql #docker #linux

本文详细介绍了使用Docker部署MySQL8.0的具体步骤，包括拉取镜像、配置文件准备、目录创建及容器运行命令。特别注意密码设置及容器端口映射。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

第一步

docker pull mysql

第二步
在宿主机创建放置mysql的配置文件的目录，和数据目录,然后创建my.cnf配置文件

mkdir /usr/local/mysql_conf

mkdir /usr/local/mysql_data

vi /usr/local/mysql_conf/my.cnf

附上mysql8.0默认的my.cnf 的内容

# Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA

#
# The MySQL  Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Custom config should go here
!includedir /etc/mysql/conf.d/

第三步
执行创建容器命令

docker run -d --name mysql -v /usr/local/mysql_conf/my.cnf:/etc/mysql/my.cnf -v /usr/local/mysql_data:/var/lib/mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root mysql

注意：密码不要设置成123456，因为mysql8.0密码校验比较严格，设置成123456去连接的时候会报mysql 2059错误
意思就是让你改密码

-v 挂载宿主机目录和 docker容器中的目录

-d 后台运行

-p 映射容器端口号和宿主机端口号

-e 环境参数