centos7 mysql5.7安装教程

1、下载mysql安装包
  160  wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

2、解压并移动到 /usr/local/mysql目录下
  162  tar -zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
  165  mv mysql-5.7.24-linux-glibc2.12-x86_64 /usr/local/mysql

3、添加mysql用户组
  167  groupadd mysql
  170  useradd -r -g mysql mysql

4、更改mysql安装包目录用户组
  173  mkdir data
  176  chown -R mysql:mysql /usr/local/mysql
  177  chmod 755 /usr/local/mysql/

5、开始编译安装，记住安装完成后的初始密码
  179  cd bin/ 
  181  ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

6、更改mysql配置文件
  185  vim /etc/my.cnf

[mysqld]
datadir=/usr/local/mysql/data
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=600
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8

7、启动mysql服务，修改登陆密码以及授权远程登录
  190  cd support-files/
  192  ./mysql.server start

set password for root@localhost = password('wu19940305')

use mysql ;

update user set user.Host='%' where user.User='root';

flush privileges;

8、创建工具软连接，加入开机自启列表
  206  ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
  207  ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
  210  service mysql restart
  213  systemctl enable mysql