centos安装mysql5.7 (docker环境)

centos安装mysql5.7 (docker环境)

1. yum安装依赖
   • yum -y install libaio numactl
   • yum -y install openssl openssl-devel如果要使用mysql的ssl加密通信则安装，否则跳过此步骤
2. 前期准备工作
   • groupadd mysql创建mysql组
   • useradd -g mysql mysql -s /sbin/nologin创建MySQL用户并且不让shell登录
   • mkdir -p /usr/local/mysql/data && cd /usr/local/mysql创建目录
   • wget -c https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz下载mysql通用二进制包
   • tar -zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz && mv mysql-5.7.24-linux-glibc2.12-x86_64/* /usr/local/mysql && cd /usr/local/mysql解压并且进入目录
   • chown -R mysql:mysql /usr/local/mysql修改mysql文件夹所属用户和组
   • /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data初始化数据库
   • /usr/local/mysql/bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/datamysql的ssl加密通信，如果不使用，则跳过此步骤
3. 配置启动MySQL
   • cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld创建unix服务
   • vim /etc/init.d/mysqld
   • 添加路径 在46行
     basedir=/usr/local/mysql
     datadir=/usr/local/mysql/data
   • vim /etc/my.cnf将一下代码复制过去

     [mysqld]
     character_set_server=utf8
     init_connect='SET NAMES utf8'
     basedir=/usr/local/mysql
     datadir=/usr/local/mysql/data
     socket=/tmp/mysql.sock
     #不区分大小写(sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 这个简单来说就是sql语句是否严格)
     lower_case_table_names = 1
     log-error=/var/log/mysqld.log
     pid-file=/usr/local/mysql/data/mysqld.pid
     

   • chkconfig --add mysqld开机启动MySQL
   • ln -s /usr/local/mysql/bin/mysql /usr/bin添加软连接
   • /etc/init.d/mysqld start启动MySQL服务
   • mysql -uroot -p登录MySQL
   • alter user 'root'@'localhost' identified by '123456';修改密码
   • grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;授权MySQL的root用户可以在任意地址登录且能将自己权限分配给别人
   • flush privileges;刷新权限