centos7-安装mysql-8.0.29

linux下安装rpm包：

rpm -ivh xxx.rpm

1、安装mysql，依次执行命令：

# 卸载mysql-libs
yum remove mysql-libs

# 解压文件
tar -xvf mysql-8.0.29-1.el7.x86_64.rpm-bundle.tar

# 安装mysql服务
rpm -ivh mysql-community-common-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.29-1.el7.x86_64.rpm

2、安装完成后，授权访问mysql：

chmod -R 777 /var/lib/mysql

# 重启mysql服务
service mysqld restart

3、获取mysql的临时密码：

grep 'temporary password' /var/log/mysqld.log

# [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: dtweptukh2<Q

4、使用临时密码连接：

mysql -u root -p

# Enter password:dtweptukh2<Q

5、设置新密码（允许设置简单密码）：

# 先设置复杂密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test@000_ccc';

# 再更改配置
set global validate_password.policy=0;
set global validate_password.length=1;

# 后设置为简单密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
flush privileges;

# 允许远程用户登录
use mysql;
update user set Host='%' where User='root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;

参考文档：

1）卸载自带mariadb；安装mysqlrpm报错mariadb已经被mysql-community-client-5.7.25-1.el7.x86_64所取代_貔貅526的博客-CSDN博客[root@localhost 5.7.25rpm]# rpm -ivh *.rpmwarning: mysql-community-client-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYerror: Failed dependencies:mariadb is obsoleted by mysql-community-client-5.7.25-1.el7.x86_64mariadb-https://blog.csdn.net/pixiu568/article/details/1102374592）rpm包安装顺序，连接密码设置；Linux系统安装Mysql完整顺序_lch1024的博客-CSDN博客_mysql安装linux顺序rpm1.安装前检查mysql是安装了其他包    # rpm -qa | grep mysql    # rpm -qa | grep Mysql    # rpm -qa | grep maridb    如果存在先卸载    # rpm -e --nodeps XXX2.官网下载mysql社区版    https://dev.mysql.com/downloads/mysql/ 选择对应系统版本的...https://blog.csdn.net/lin360225013/article/details/798198263）允许设置简单密码；解决MySQL8.0报错：Unknown system variable 'validate_password_policy' - 遠離塵世の方舟 - 博客园一、问题描述 1、在安装MySQL8.0时，修改临时密码，因密码过于简单（如：123456），不符合MySQL密码规范，会触发一个报错信息： ERROR 1819 (HY000): Your passhttps://www.cnblogs.com/rusking/p/10561432.html

4）允许远程连接数据库。

Operation ALTER USER failed for ‘root‘@‘%‘_丶Summer℡ 念~的博客-CSDN博客解决mysql Operation ALTER USER failed for ‘root’@’%' 1、连接服务器: `mysql -u root -p`2、看当前所有数据库：show databases;3、进入mysql数据库：use mysql;4、查看mysql数据库中所有的表：show tables;5、查看user表中的数据：select Host, User from user;6、修改user表中的Host: update user shttps://blog.csdn.net/qq_36501494/article/details/121571843