CentOS8 rpm 安装 mysql 5.7

1.下载
    wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

 
2.    解压
    tar -xvf mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

 
3.    准备就绪 查看旧版本
1）    rpm -qa | grep mysql
    如果没有继续
 
2）    清除yum mysql所有依赖包
    yum remove mysql-libs
 
3）    rpm -qa | grep mariadb;
    卸载掉自带的mariadb
    rpm -e mariadb-libs-5.5.52-1.el7.x86_64 --nodeps;
 
4）    rpm -qa|grep libaio
    如果没有就安装
    yum -y install libaio
 
4.    安装perl包
    RHEL，CentOS等发行版：sudo yum -y install perl-CPAN
    Ubuntu，Debian等发行版：sudo apt-get install perl-modules
 
5.    安装mysql
   1. rpm -ivh mysql-community-common-5.7.36-1.el7.x86_64.rpm
   2. rpm -ivh mysql-community-libs-5.7.36-1.el7.x86_64.rpm
   3. rpm -ivh mysql-community-client-5.7.36-1.el7.x86_64.rpm

若有错误:

# rpm -ivh mysql-community-client-5.7.36-1.el7.x86_64.rpm 
warning: mysql-community-client-5.7.36-1.el7.x86_64.rpm: Header V3 DSA/SHA256 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
	libncurses.so.5()(64bit) is needed by mysql-community-client-5.7.36-1.el7.x86_64
	libtinfo.so.5()(64bit) is needed by mysql-community-client-5.7.36-1.el7.x86_64

则执行

 yum install libncurses*

来安装依赖
  4.  rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm

若出现警告:

[/usr/lib/tmpfiles.d/mysql.conf:23] Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly.
[/usr/lib/tmpfiles.d/radvd.conf:1] Line references path below legacy directory /var/run/, updating /var/run/radvd → /run/radvd; please update the tmpfiles.d/ drop-in file accordingly.

则分别执行:

vim  /usr/lib/tmpfiles.d/radvd.conf
vim /usr/lib/tmpfiles.d/mysql.conf

进入文件中将"/var"删除后保存退出
 
6.    启动服务
    systemctl start mysqld.service    启动mysql
    systemctl status mysqld.service  查看mysql状态
    systemctl stop mysqld.service   关闭mysql
 
    查看mysql进程 ps -ef|grep mysql
    查看3306端口 netstat -anop|grep 3306
 
7.    登录mysql 获取临时密码
#/var/log/mysqld.log文件是安装MySQL的日志文件，里面有初始化密码。

cat /var/log/mysqld.log | grep password
 
    mysql -uroot -p 
    输入临时密码
 
    输入quit 或 exit 都能退出mysql
 
8.    更改密码安全策略
    set global validate_password_policy=0;
    set global validate_password_length=1;
 
9.    重设密码
    set password for root@localhost=password('123456');
 
10.    授权远程登录
    第一种（创建新用户）
    use mysql;//选择数据库
 
    select user,host from user;//查看所有用户
 
    create user 'sunup'@'%' identified by 'shewWE6723&^23.';//创建用户
 
    grant all privileges on *.* to sunup@'%' identified by 'shewWE6723&^23.';//授予远程登录权限
 
    flush privileges;//刷新配置
第二种 在root用户上操作
mysql>use mysql;
msyql>update user set user.Host='%' where user.User='root';
mysql>flush privileges;