1.安装前,先检查系统自带的mariadb是否存在,如存在则需要卸载
rpm -qa | grep mariadb
rpm -e --nodeps `rpm -qa | grep mariadb`
2.上传并解压缩mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar
tar -zxvf mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar
3.使用rpm方式一次安装mysql依赖
rpm -ivh mysql-community-common-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.33-1.el7.x86_64.rpm
rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.33-1.el7.x86_64.rpm
4.初始化数据库
mysql_install_db --datadir=/var/lib/mysql
mysqld --initialize
5.修改/etc/my.cnf配置文件
[client]
#默认连接端口
port = 3306
#用于本地连接的socket套接字
socket = /var/lib/mysql/mysql.sock
#编码
default-character-set = utf8mb4
[mysqld]
datadir=/var/lib/mysql/data
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#MySQL监听端口
port = 3306
6.更改mysql数据库目录的所属用户及其所属组,并启动mysql数据库
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
7./etc/my.cnf文件中mysqld部分添加skip-grant-tables
#用于首次登录跳过密码校验
skip-grant-tables
8.重启mysql服务并登录
mysql
9.选择mysql数据库实例,并修改root密码
set global validate_password_policy=0;
set global validate_password_length=1;
#修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
#授权任何主机
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
#授权指定主机
GRANT ALL PRIVILEGES ON *.* TO 'xxxx'@’xx.xx.xx.xx’ IDENTIFIED BY 'xxxx' WITH GRANT OPTION;
# 然后刷新权限
flush privileges;