• docker安装mysql


    docker安装mysql并配置宿主机挂载目录。

    docker run -d -e MYSQL_ROOT_PASSWORD=rootPwd --name mysql8 -v /home/docker/docker-mysql/my.cnf:/etc/mysql/my.cnf -v /home/docker/docker-mysql/mysql-files:/var/lib/mysql-files/ -v /home/docker/docker-mysql/data:/var/lib/mysql -p 3306:3306 mysql:8.0

    需要着重说的:
    MYSQL_ROOT_PASSWORD : 登录密码
    mysql:8.0:下载mysql的版本
    其他的就是挂载目录的配置 端口号 。

    配置文件 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/
    
    sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
    
    lower_case_table_names = 1
    

    mysql大小写配置要在初始化之前配置,如果初始化后配置的需要把挂载目录下data中的库表信息删除。

  • 相关阅读:
    Django框架之第三篇模板语法
    Django框架之第二篇
    Django框架第一篇基础
    【数学基础】【快速幂运算模板】
    【搜索】【广搜模板】
    【动态规划】【子序列模板】
    [置顶] 【ACM模板】——hello_chengdongni 随着姿势提升,不定期补充
    【搜索入门专题1】 hdu1242 J
    【搜索入门专题1】E
    【搜索入门专题1】hdu1253 【BFS】 F
  • 原文地址:https://www.cnblogs.com/pengcool/p/15516488.html
Copyright © 2020-2023  润新知