centos8（redhat、linux）安装mysql8.0 超详细教程

1、安装参考 

CentOS8 安装 MySQL8.0（RPM）_bellus-的博客-CSDN博客_centos8 安装rpm

注意补充（对上面的博客的补充）：

1.需先卸载mariadb

2.安装包安装顺序

解压一下tar包

mysql-8.0.30-1.el7.x86_64.rpm-bundle.tar

解压后包含以下文件。红色是安装server所需依赖，见下图 

mysql-community-client-8.0.30-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.30-1.el7.x86_64.rpm
mysql-community-common-8.0.30-1.el7.x86_64.rpm
mysql-community-debuginfo-8.0.30-1.el7.x86_64.rpm
mysql-community-devel-8.0.30-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.30-1.el7.x86_64.rpm
mysql-community-icu-data-files-8.0.30-1.el7.x86_64.rpm
mysql-community-libs-8.0.30-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.30-1.el7.x86_64.rpm
mysql-community-server-8.0.30-1.el7.x86_64.rpm
mysql-community-server-debug-8.0.30-1.el7.x86_64.rpm
mysql-community-test-8.0.30-1.el7.x86_64.rpm

安装依赖顺序 如下图

3.需先设置表明忽略大小写，再初始化数据库。推荐配置如下  

MySQL配置表名大小写敏感、字段名大小写敏感、字段值大小写敏感。lower_case_file_system、lower_case_table_names、utf8mb4_bin_茅坑的小石头的博客-CSDN博客_表名大小写敏感

[mysqld]

#add by lishuoboy 20221118 start

# 忽略表名大小写敏感
lower_case_table_names=1

# 端口
port=3306

# 默认字符集。一般默认是 utf8mb4
character-set-server=utf8mb4

# 默认排序规则。一般默认是 utf8mb4_0900_ai_ci 或 utf8mb4_general_ci 。ci:大小写不敏感; cs:大小写敏感； bin：二进制，也大小写敏感
collation_server=utf8mb4_bin

#add by lishuoboy 20221118 end

4.安全设置可以跳过，初始密码登陆后直接重置密码

mysql8.0修改用户密码_茅坑的小石头的博客-CSDN博客

2、设置mysql对所有ip都可访问

use mysql;

update user set host = '%' where user ='root';

flush privileges;

select host,user from user where user='root';

详见：

mysql 错误代码1130_mysql出现错误码1130怎么办_Clever Liu的博客-CSDN博客

3、mysql忘记密码，重置密码（第1步也里有）：

Linux服务器下MySQL 8.0 重置密码 修改密码 - 知乎