先下载mysql的安装包 一共这几种
mysql-community-client.x86_64 8.0.16-2.el7 mysql-community-common.x86_64 8.0.16-2.el7mysql-community-libs.x86_648.0.16-2.el7 mysql-community-libs-compat.x86_64 8.0.16-2.el7 mysql-community-server.x86_648.0.16-2.el7 mysql-connector-java.noarch 1:5.1.25-3.el7 mysql-connector-odbc.x86_64 5.2.5-6.el7
yum安装mysqld
[root@xiaoyaoji ~]# yum -y install mysql-server[root@xiaoyaoji ~]# vi /etc/f##在最后一行添加skip-grant-tables[root@xiaoyaoji ~]# systemctl start mysqld[root@xiaoyaoji ~]# mysql -uroot -pEnter password:## 直接回车mysql> use mysql; ## 进入mysql表mysql> update user set authentication_string='' where user='root';## 将密码设置为空（必须在mysql库设置）mysql> quti[root@xiaoyaoji ~]# vi /etc/f ##将添加的skip那一行删除，然后重启服务；[root@xiaoyaoji ~]# systemctl restart mysqld[root@xiaoyaoji ~]# mysql -uroot -pEnter password:##直接回车mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Root@123'; ##设置密码（密码要复杂一点，否指会报错）mysql> exit
接下来进行mysql的授权，对访问mysql的主机进行授权，否则访问不了
[root@xiaoyaoji ~]# mysql -uroot -pRoot@123 ##尽量不要在命令行输入密码；在mysql8.0中 授权语句已经更换，使用之前的sql语句授权会报错；mysql> create user 'root'@'%' identified by 'Root@123'; ##创建可以所有用户都可以访问的用户规则mysql> grant all privileges on *.* to 'root'@'%'; ##对这个用户规则进行授权mysql> flush privileges; ##刷新权限mysql> exit
