05_redhat安装mysql5.7.35

1.卸载mariadb

yum remove mariadb -y
yum remove mysql -y

2.查找mariadb包

rpm -qa | grep mariadb
yum remove mariadb-libs-5.5.68-1.el7.x86_64 -y
[root@Jsls ~]# yum remove mariadb-connector-c-3.1.11-2.el8_3.x86_64 -y

3.删除遗留文件（没有就不用删除）

rm -rf /var/lib/mysql/
wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm

4.上传mysql rpm包

5.解压到/software/mysql-5.7.35文件夹下

mkdir -p /soft/mysql
tar -xvf mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar -C /soft/mysql

6.rpm安装

使用命令rpm -ivh (file-name)进行安装操作

执行命令如果报错
是因为还缺少另外两个安装包，才能解决完整的依赖，执行以下命令进行安装：
sudo yum install libncurses*
然后再次执行下列依赖安装命令

mysql-5.7.35依赖关系及安装
rpm -ivh mysql-community-common-5.7.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.35-1.el7.x86_64.rpm
yum install -y net-tools
rpm -ivh mysql-community-server-5.7.35-1.el7.x86_64.rpm

7.启动mysql服务

systemctl start mysqld
设置开机启动
systemctl enable mysqld  

8.找密码

cd /var/log  目录下的mysqld.log文件
vim mysqld.log
搜索密码字段
grep password /var/log/mysqld.log
密码.rwX<t;ek3T1

9.输入密码进入数据库

mysql -u root -p
password: i!gNWc<ji5+P

10.第一次进入数据库需要修改密码

set global validate_password_policy=LOW; 
set global validate_password_length=4;
alter user 'root'@'localhost' identified by '123456';
打开远程连接
update mysql.user set host='%' where user='root';
刷新授权
flush privileges;
退出
quit

11.修改编码

vim /etc/my.cnf
在[mysqld]下添加:
character-set-server=utf8

12.退出保存并重启服务

service mysqld restart

13.重启，终端工具远程访问连接数据库

reboot