Centos7安装mysql5.7

1.下载安装包

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

2.创建一个mysql用户用于启动mysql

useradd mysql

3.解压

tar zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz -C /usr/local/

4.创建一个软链接

#进入 usr/local/mysql 目录
ln -s mysql-5.7.24-linux-glibc2.12-x86_64 mysql

5.给予权限

chown -R mysql:mysql ./

6.初始化

#进入 usr/local/mysql 目录
./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize
# 将生成的密码保存起来

7.修改配置文件

# vim /etc/my.cnf
​
#文件如下
[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
explicit_defaults_for_timestamp=true
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
​
[mysqld_safe]
log-error=/usr/local/mysql/data/mysql.log
pid-file=/usr/local/mysql/data
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d                                  

8.将mysql服务添加到系统中

#进入 usr/local/mysql 目录  依次执行指令
#切换hadoop用户执行
cp support-files/mysql.server /etc/init.d/mysqld
ls -l /etc/init.d/mysqld
service  mysqld start

9.将mysql指令添加到系统指令中

 ln -s /usr/local/mysql/bin/* /usr/local/bin/

10.初始化mysql

mysql -u root -p  
#密码为刚才记录的初始化密码
#修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'New12345678!';
mysql>use mysql;
#开放远程连接
msyql>update user set user.Host='%' where user.User='root';
mysql>flush privileges;