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.需先设置表明忽略大小写,再初始化数据库。推荐配置如下
[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博客