安装mysql5.7.28指令整理

安装mysql5.7.28指令整理：

一、开始按顺序安装rpm包

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

//先看下服务器有没有这个包，以防止版本冲突

rpm -qa | grep mariadb

//如果有 就执行命令删除

rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps

//开始安装

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-devel-5.7.28-1.el7.x86_64.rpm

注意：如果报如下异常

错误：依赖检测失败： /usr/bin/perl 被 mysql-community-server-5.7.28-1.el7.x86_64 需要 perl(Getopt::Long) 被 mysql-community-server-5.7.28-1.el7.x86_64 需要 perl(strict) 被 mysql-community-server-5.7.28-1.el7.x86_64 需要

解决方案：执行 yum install -y perl-Module-Install.noarch

二、初始化mysql

mysqld --initialize --user=mysql

三、查看自动生成的mysql密码

cat /var/log/mysqld.log

四、开启服务器全局启动

systemctl start mysqld.service

//查看服务开启状态

systemctl status mysqld.service

五、登录mysql 修改密码

mysql -uroot -p

//进入到终端执行修改密码为root

set password=password('root');

六、关防火墙等权限

systemctl stop iptables

systemctl stop firewalld

//禁用（服务器永久禁用）

systemctl disable firewalld.service
 

net-tools is needed by mysql-community-server-5.7.21-1.el7.x86_64

yum -y install net-tools