centos7安装mysql8.0

1.安装mysql客户端，用于连接mysql服务。

yum install mysql

2.复制mysql的rpm下载地址（官网的下载地址：https://dev.mysql.com/downloads/repo/yum/,需要登入）

3.centos7下载mysql的rpm

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

4.安装mysql的rpm

rpm -ivh mysql80-community-release-el7-3.noarch.rpm

5.安装mysql服务

yum install mysql-server

6.修改/etc/my.cnf 文件，不用密码登入

vi /etc/my.cnf
#添加
skip-grant-tables

7.启动并连接mysql服务

#启动
systemctl start mysqld
#连接 
mysql -uroot -p #回车 回车

8.修改密码

#刷新权限
mysql> flush privileges;  
Query OK, 0 rows affected (0.01 sec)
#查看验证
mysql> show variables like "%validate%";
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password.check_user_name    | ON     |
| validate_password.dictionary_file    |        |
| validate_password.length             | 8      |
| validate_password.mixed_case_count   | 1      |
| validate_password.number_count       | 1      |
| validate_password.policy             | MEDIUM |
| validate_password.special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.01 sec)
#修改密码最短长度6
mysql> set global validate_password.length=6;
Query OK, 0 rows affected (0.00 sec)
#修改密码简单规则
mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)
#修改密码
alter user 'root'@'localhost' identified with mysql_native_password by '123456';
#刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

9.允许远程访问

#使用mysql数据库
mysql> use mysql
Database changed
#查看用户允许访问的host
mysql> select host,user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.00 sec)
#修改root的host
mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0
#刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

10.注释/etc/my.cnf 的skip-grant-tables ,重新启动mysql服务

vi etc/my.cnf

#skip-grant-tables

#启动mysql服务
[root@VM-0-17-centos ~]# systemctl restart mysqld
[root@VM-0-17-centos ~]# 

11.卸载mysql服务

#删除安装
#rpm -qa |grep -i mysql | xargs yum remove -y
#删除有关文件
#find / -name mysql | xargs rm -rf
#删除/etc/my.cnf
rm -rf /etc/my.cnf
#删除log
rm -rf /var/log/mysqld.log