centos安装mysql5.7 (docker环境)

centos安装mysql5.7 (docker环境)

1. yum安装依赖
   • yum -y install libaio numactl
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 --user=mysql -- dir=/usr/local/mysql --datadir=/usr/local/mysql/data初始化数据库
3. 配置启动MySQL
   • cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld创建unix服务
   • vim /etc/init.d/mysqld
   • 添加路径 在46行
     dir=/usr/local/mysql
     datadir=/usr/local/mysql/data
   • 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刷新权限