1、查看系统自带的Mariadb

rpm -qa|grep mariadb

若存在: mariadb-libs-5.5.64-1.el7.x86_64

不存在:

2、卸载系统自带的Mariadb

rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64

3、检查MySQL是否存在

rpm -qa | grep mysql

若存在:

不存在:

4、检查用户和组是否存在

检查用户:

cat /etc/passwd | grep mysql

检查用户组:

cat /etc/group | grep mysql

5、不存在创建用户和组

创建mysql用户组:

groupadd mysql

创建mysql用户:

useradd -g mysql mysql

设置密码:

passwd mysql

6、上传MySQL资源包

将 mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz 压缩包上传到 /usr/local/ 目录下

7、解压

tar -zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz

重命名文件夹:

mv mysql-5.7.35-linux-glibc2.12-x86_64 mysql

进入目录:

cd /usr/local/mysql/

创建数据目录:

mkdir data

创建日志目录:

mkdir log

创建运行目录:

mkdir run

mkdir run/mysqld

上传 my.cnf 配置文件到 /usr/local/mysql/ 目录下

my.cnf 内容:

[mysqld]
socket=/usr/local/mysql/mysql.sock
# set mysql server port  
port = 3306
# set mysql install base dir
basedir=/usr/local/mysql
# set the data store dir
datadir=/usr/local/mysql/data
# set the number of allow max connnection
max_connections=3000
# set server charactre default encoding
character-set-server=utf8
# set is case insensitive
lower_case_table_names=1

max_allowed_packet=16M

init_connect=‘SET NAMES utf8’

log-error=/usr/local/mysql/log/mysqld.log

pid-file=/usr/local/mysql/run/mysqld/mysqld.pid

[mysql.server]
user=mysql

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

进入目录:

cd /usr/local

更改目录所属组和用户:

更改所属组:

chown -R mysql mysql/

更改所属用户:

chgrp -R mysql mysql/

检查目录:

ll

8、安装MySQL

进入初始化目录:

cd /usr/local/mysql

初始化数据库:

./bin/mysqld --initialize --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

查看数据库初始化密码:

grep 'temporary password' /usr/local/mysql/log/mysqld.log

复制配置文件:

cp /usr/local/mysql/my.cnf /etc/my.cnf

9、设置开机自启动

复制启动文件:

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

赋权:

chmod +x /etc/init.d/mysqld

赋予mysql用户mysql目录执行权限:

chown -R mysql.mysql /usr/local/mysql/

添加为服务:

chkconfig --add mysqld

查看服务列表:

chkconfig --list 看到3、4、5状态为开或者为 on 则表示成功

10、启动MySQL

启动:

/etc/init.d/mysqld start

重启:

/etc/init.d/mysqld restart

服务可选项:

11、登录MySQL

编辑环境变量:

vim /etc/profile

在末尾换行添加内容: export PATH=$PATH:/usr/local/mysql/bin

生效环境变量:

source /etc/profile

登录MySQL:

mysql -u root -p 输入初始化密码

登录后修改密码:

set password=password("Ysxx@1234");

创建远程登陆用户:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Ysxx@1234';

刷新:

flush privileges;

12、退出登录

退出:

exit

MySQL5.7 安装完毕