centos8安装MySQL(5.7版本)

下载MySQL(5.7版本)的yum源

wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'

安装MySQL的yum源

rpm -Uvh mysql57-community-release-el7-11.noarch.rpm
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

安装MySQL

yum module disable mysql
yum -y install mysql-community-server

查看MySQL启动状态

systemctl status mysqld

启动MySQL服务

systemctl start mysqld

添加MySQL服务到开机启动

systemctl enable mysqld

设置数据库允许远程连接访问，查看源码安装的MySQL的密码

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

在Linux下登录mysql服务器

mysql -uroot -p

如果密码长度

set global validate_password_policy=0;
set global validate_password_length=1;

修改数据库密码

set password for root@localhost = password('123456');

切换到mysql库

use mysql;

查看主机及用户信息

select host,user from user;

赋予任何主机访问数据的权限

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

刷新权限使其生效

flush privileges;