1: 下载安装包
直接下载mysql-5.7.21-1.el7.x86_64.rpm-bundle.tar,所有的rpm包都在里面
https://dev.mysql.com/downloads/mysql/
选择Red Hat Enterprise Linux 7 / Oracle Linux 7 ,把os的版本选择为all
安装之前先卸载自带的mysql
搜索mysql的rpm包
rpm -qa |grep -i mysql
rpm -qa |grep -i mariadb
删除mysql
rpm -e mariadb-libs-5.5.35-3.el7.x86_64 --nodeps
rpm -e mysql-xxx-5.5.35-3.el7.x86_64 --nodeps
再安装mysql需要的依赖包 libaio依赖 和 net-tools 依赖
yum -y install libaio
yum -y install net-tools
2 : 解压安装包,依次安装一下rpm包
rpm -ivh mysql-community-common-5.7.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.21-1.el7.x86_64.rpm
3,
停止服务
service mysqld stop
编辑
vi /etc/my.cnf
添加
skip-grant-tables #添加这句话,这时候登入mysql就不需要密码
symbolic-links=0
开启服务
service mysqld start
mysql> mysql -uroot -p
回车
刷新权限
mysql>flush privileges;
设置密码
mysql>set password for root@localhost = password('123456');
刷新权限
mysql>flush privileges
重启服务
service mysqld restart
设置开机启动
systemctl enable mysqld
3 : 开放mysql远端访问
select user,host from user;
update user set host='%' where user='root';
flush privileges;
4: 关闭防火墙
systemctl stop firewalld
systemctl disable firewalld