centOs7 安装mysql5.7镜像

105 阅读1分钟
  • 查看当前系统内

uname -r

  • 更新yum包

    yum -y update

 升级所有包同时也升级软件和系统内核;

yum -y upgrade

 只升级所有包,不升级软件和系统内核;

  • 安装docker

    yum install -y yum-utils device-mapper-persistent-data lvm2

  • 设置yum源

    yum-config-manager --add-repo mirrors.aliyun.com/docker-ce/l…

  • 选择docker版本

    yum list docker-ce --showduplicates | sort -r

  • 安装docker

    yum -y install docker-ce-18.03.1.ce

  • 启动docker

    systemctl start docker systemctl enable docker --设置开机自启 systemctl status docker --查看是否启动成功

  • 拉取mysql镜像

    docker pull mysql:5.7

  • 创建配置文件

    cd /home/dockerdata/mysql/conf/ vi my.cnf

    Copyright (c) 2014, 2016, 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

    dev.mysql.com/doc/mysql/e…

    [mysqld] pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock datadir = /var/lib/mysql #log-error = /var/log/mysql/error.log

    Disabling symbolic-links is recommended to prevent assorted security risks

    symbolic-links=0

    max_connections = 2000 max_user_connections = 1900 max_connect_errors = 100000 max_allowed_packet = 50M lower_case_table_names=1 [mysqld] skip-name-resolve sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

  • 运行mysql

    docker run -p 3307:3306 --name mysql -v /home/dockerdata/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /home/dockerdata/mysql/logs:/logs -v /home/dockerdata/mysql/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7