百度网盘：https://pan.baidu.com/s/1RcKct7_CffWK5bRgzUNNLQ?_at_=1624090494933
下载地址：https://dev.mysql.com/downloads/mysql/
选择如下：
【Red Hat Enterprise Linux 7 / Oracle Linux】
【Red Hat Enterprise Linux 7 / Oracle Linux 7 (x86, 64-bit)】
先查看一下是否已经安装了，命令：rpm -qa|grep mariadb
删除mariadb，命令：rpm -e --nodeps mariadb-libs
tar -xvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
解压缩之后，包含以下rpm包
[root@localhost mysql]# pwd /usr/local/mysql [root@localhost mysql]# ls mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar mysql-community-client-8.0.19-1.el7.x86_64.rpm mysql-community-common-8.0.19-1.el7.x86_64.rpm mysql-community-devel-8.0.19-1.el7.x86_64.rpm mysql-community-embedded-compat-8.0.19-1.el7.x86_64.rpm mysql-community-libs-8.0.19-1.el7.x86_64.rpm mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm mysql-community-server-8.0.19-1.el7.x86_64.rpm mysql-community-test-8.0.19-1.el7.x86_64.rpm [root@localhost mysql]#
逐个安装，命令如下：
【必须安装】
rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm
【非必须安装】
rpm -ivh mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-test-8.0.16-2.el7.x86_64.rpm
最后一个依赖于net-tools
yum -y install net-tools
安装完成
1，初始化数据库
命令：mysqld --initialize --console
2，目录授权
命令：chown -R mysql:mysql /var/lib/mysql/
3，启动mysql服务
命令：systemctl start mysqld
查看状态
命令：systemctl status mysqld
1、查看临时密码：
命令：cat /var/log/mysqld.log
[root@localhost mysql]# grep ‘temporary password‘ /var/log/mysqld.log 2021-06-20T04:05:43.322571Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ypj(aM*b)1q2 [root@localhost mysql]#
2、用临时密码登录数据库
命令：mysql -u root -p 回车键
然后输入临时密码（输入时不会显示出来，输入完直接回车）
3、修改mysql密码
命令：alter USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘123456‘;
如果前面三步因为密码复杂度无法修改密码，请使用以下步骤
[root@server-10 ~]# vim /etc/my.cnf skip-grant-tables #新增该行，跳过权限表，这样启动数据库以后，就可以无密码登录！
#重启mysld服务 [root@localhost mysql]# systemtl restart mysqld #进入mysql [root@localhost mysql]# mysql -uroot //查看参数 mysql> SHOW VARIABLES LIKE ‘validate_password%‘;
然后修改参数(参考：https://blog.csdn.net/ssiyla/article/details/82931439)
mysql> set global validate_password.policy=0; mysql> set global validate_password.length=1;
然后修改自己的密码为简单的密码就行了。
mysql> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘jws.com‘;
最后记得修改/etc/my.cnf，注释掉skip-grant-tables
[root@localhost mysql]# systemctl restart mysqld #重启mysqld后，进入mysql [root@localhost mysql]# mysql -uroot -ph3c.com #设置允许被任意IP地址访问 mysql> update mysql.user set host = ‘%‘ where user = ‘root‘; 然后让改动生效 mysql> flush privileges;
4、授权远程连接
mysql8.0开启远程方式和5.0的不同
#重新创建一个用户
mysql> create user ‘jws‘@‘%‘ identified by ‘jws.com‘; Query OK, 0 rows affected (0.05 sec) #开启远程权限 mysql> GRANT ALL PRIVILEGES ON *.* TO ‘jws‘@‘%‘; Query OK, 0 rows affected (0.08 sec) #开启用Navicat连接的回报不支持caching_sha2_password验证方式的错误。将远程访问用户的验证方式改为： msyql_native_password mysql> ALTER USER ‘jws‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘jws.com‘; Query OK, 0 rows affected (0.06 sec)
#刷新 mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql>
使用navacat远程连接
记得开放防火墙3306端口或者关闭防火墙
原文：https://www.cnblogs.com/yizhipanghu/p/14906595.html