解压安装包

tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

环境准备

因为用的centos7，自带了mariadb数据库，需要进行删除
rpm -qa|grep maridb //查找mariadb数据库
rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 —nodeps //删除

安装MySQL

rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm

初始化MySQL

mysqld —initialize —user=mysql

查看日志

cat /var/log/mysqld.log
在日志的最后一行会看到随机生成的初始密码

运行MySQL

systemctl start mysqld.service
systemctl status mysqld.service

更改密码

mysl -uroot -p //用初始密码登录MySQL
set password=password(‘root’); //更改密码为root

防火墙处理

方便后期练习数据库，关闭防火墙
systemctl stop iptables/firewalld
systemctl disable firewalld.service // 防止虚拟机开启时防火墙开启

账号没有权限登录问题

执行 use mysql,会发现当前账号只有读的权限

select host from user where user=’root’;

修改帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入MySQL后，更改 “mysql” 数据库里的 “user” 表里的 “host” 项，从”localhost”改称”%”

update user set host = ‘%’ where user =’root’;

刷新配置

flush privileges;