环境说明：

CentOS 8

MySQL8.0.17

一、下载安装MySQL官方的Yum Repository

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

二、安装需要的Yum Repository

yum -y install mysql57-community-release-el7-10.noarch.rpm

图示

三、yum安装MySQL

yum -y install mysql-server mysql mysql-devel

图示

四、查看安装的mysql的相关信息

rpm -qi mysql-server

图示

五、启动MySQL服务并设置开机启动

?systemctl start mysqld

systemctl enable mysqld

?systemctl daemon-reload

端口开放

?firewall-cmd –zone=public –add-port=3306/tcp –permanent

?firewall-cmd –reload

图示

修改root本地登录密码

查看mysql密码

cat? /var/log/mysql/mysqld.log

图示

可见密码为空

连接mysql：

mysql -uroot -p

修改密码：

修改密码【注意：后面的分号肯定要跟上】

mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘123456’;

或者者：

mysql> set password for ‘root’@’localhost’=password(‘123456’);

mysql> show variables like ‘%password%’;

图示

增加远程登录客户

GRANT ALL PRIVILEGES ON *.* TO ‘lidongfang’@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;

中止mysql：

service mysqld stop

图示

显示mysql客户权限权限：

show grants for ‘客户名’@’ip’

图示

图示