centos8 yum方式安装mysql8

采用yum安装，可以简化安装步骤。在没有特殊需求的情况下，该安装方式是合适的。

https://dev.mysql.com/downloads/repo/yum/

wget https://repo.mysql.com/mysql80-community-release-el8-3.noarch.rpm

# yum localinstall mysql80-community-release-el8-3.noarch.rpm

# yum repolist enabled | grep "mysql.-community*"
Repository base is listed more than once in the configuration
Repository updates is listed more than once in the configuration
Repository extras is listed more than once in the configuration
Repository centosplus is listed more than once in the configuration

yum module disable mysql

yum install mysql-community-server

vim /etc/my.cnf

设置大小写不敏感。 如果有端口冲突，可以设置单独的端口。密码加密算法插件。

相关参数配置项根据需要添加。

#让MYSQL大小写敏感(1-不敏感，0-敏感)
lower_case_table_names=1

port=13306

default_authentication_plugin=mysql_native_password

systemctl start mysqld

查看mysql服务启动状态

systemctl status mysqld

grep ‘temporary password’ /var/log/mysqld.log

mysql -uroot -p

输入临时密码。

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

# 创建权限记录：
mysql> CREATE user 'root'@'%' IDENTIFIED BY '您的密码';

# 授权：
mysql> GRANT ALL PRIVILEGES ON . TO 'root' @'%' WITH GRANT OPTION;

# 修改密码过期策略：
mysql> ALTER USER 'root' @'localhost' IDENTIFIED BY '您的密码' PASSWORD EXPIRE NEVER;

# 重新修改密码：
mysql> ALTER USER 'root' @'%' IDENTIFIED WITH mysql_native_password BY '您的密码';

# 刷新权限：
mysql> FLUSH PRIVILEGES;