CentOS 8 安装 MySQL 8

wget https://dev.mysql.com/get/mysql80-community-release-el8-4.noarch.rpm;
rpm -ivh mysql80-community-release-el8-4.noarch.rpm;
systemctl enable mysqld;
systemctl start mysqld;

查看初始密码：

grep "password" /var/log/mysqld.log

设置：

lower_case_table_names=1
default-time_zone = '+8:00'

以指定设置创建数据库:

mysqld --defaults-file=my.ini --initialize –console

创建root@%用户：

create user 'root'@'%' identified by 'JoyCode@2022';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;#8以后
flush privileges;