mysql-5.7.20 安装

os: centos release 6.5
db:mysql-5.7.20

1.下载mysql
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz

2.安装
tar -zxvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz /opt/mysql/

1. 重命名文件夹
   cd /opt/mysql
   mv mysql-5.7.20-linux-glibc2.12-x86_64/ mysql-5.7.20

4.创建软链接
ln -s /opt/mysql/mysql-5.7.20/ /usr/local/mysql/

5.创建用户
groupadd mysql
useradd -M -g mysql -s /sbin/nologin -d /usr/local/mysql mysql

6.根据配置文件创建目录
mkdir /data/mysql/mysql_3306
cd /data/mysql/mysql_3306/
mkdir data
mkdir logs
mkdir tmp
chown -R mysql:mysql /data/mysql/mysql_3306

7.创建配置文件
vi /etc/my.cnf
datadir=/data/mysql/mysql_3306/data
basedir=/user/local/mysql
（详细略）

8.初始化数据库
cd /user/local/mysql
./bin/mysqld –initialize

9.获取初始密码
cd /data/mysql/mysql_3306/data
grep ‘password’ error.log
2017-12-23T11:50:26.431536Z 1 [Note] A temporary password is generated for root@localhost: 69ya_Gi77Oul
密码：69ya_Gi77Oul

10.创建启动脚本
cd /user/local/mysql
cp support-files/mysql.server /etc/init.d/mysqld
/etc/init.d/mysqld restart

11.登录/修改密码
mysql -u root -p
alter user user() identified by ‘123456’;
flush privileges;

12.创建数据库用户
CREATE USER “test”@”%” IDENTIFIED BY “123456”
grant all privileges on . to test@% identified by ‘123456’;

13.防火墙开放3306端口
vi /etc/sysconfig/iptables
-A INPUT -p tcp –dport 3306 -j ACCEPT

退出重启防火墙
service iptables restart