centos 7 离线安装 mysql 5.7.31

一，安装包下载
https://dev.mysql.com/downloads/mysql/5.7.html

二，删除mariadb

rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

三，解压，重命名

tar -xvf mysql-5.7.31-linux-glibc2.12-x86_64.tar
tar -zxvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.31-linux-glibc2.12-x86_64 mysql-5.7.31

四，创建数据目录

cd /usr/local/mysql-5.7.31
mkdir data
mkdir log
mkdir tmp

五，创建用户组与用户权限

groupadd mysql
useradd -g mysql mysql
passwd mysql
chown -R mysql:mysql /usr/local/mysql-5.7.31

六，创建配置表

vi /etc/my.cnf

内容如下：

[client]
port = 3306
socket = /usr/local/mysql-5.7.31/tmp/mysql.sock

[mysqld]
port = 3306
basedir = /usr/local/mysql-5.7.31
datadir = /usr/local/mysql-5.7.31/data
tmpdir  = /usr/local/mysql-5.7.31/tmp
socket = /usr/local/mysql-5.7.31/tmp/mysql.sock
pid-file = /usr/local/mysql-5.7.31/log/mysql.pid
log_error = /usr/local/mysql-5.7.31/log/error.log
slow_query_log_file = /usr/local/mysql-5.7.31/log/slow.log
explicit_defaults_for_timestamp=true
lower_case_table_names=1

七，数据库初始化

./mysqld --initialize --user=mysql

八，设置开机自启动mysql服务

cp /usr/local/mysql-5.7.31/support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld

九，切换用户启动

su mysql
service mysqld start

十，配置环境变量

vi /etc/profile

在最后增加下面代码

export PATH=$PATH:/usr/local/mysql-5.7.31/bin

生效配置

source /etc/profile

十一，更改密码

cd log/
vi error.log
/password  #查找初始密码

登录mysql

mysql -uroot -p
#更新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123456';
flush privileges;
#开启远程
#grant all privileges  on *.* to root@'%' identified by 'root123456';
show databases;
use mysql;
update user set host="%" where user='root';
flush privileges;
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;
exit;