centos7安装mysql

一、YUM在线安装程序（简单快捷）

上传依赖包：
mysql-community-release-el6-5.noarch.rpm

在当前目录下（就是上传的依赖包目录）

1. yum -y localinstall mysql-community-release-el6-5.noarch.rpm
2. yum -y install mysql-server

等待安装（需要连网）

二、RPM软件包安装

#查看mysql是否安装，如果安装了，卸载mysql

 rpm -qa|grep mysql #如果出现下面的提示，就说明系统已经有了 mysql，要卸载 
 mysql-libs-5.1.73-7.el6.x86_64

#卸载mysql
rpm -e --nodeps mysql-libs-5.1.73-7.el6.x86_64

版本及压缩包：
mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

1、准备mysql的软件包，上传到相应的目录下，比如root的家里

2、将mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar 打包文件，进行拆包

tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
(这里上传的文件只是打包了，并没有压缩)

出现

mysql-community-embedded-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-test-5.7.28-1.el7.x86_64.rpm
mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.28-1.el7.x86_64.rpm

3、安装mysql所依赖的环境perl，移除mysql的冲突软件mariadb

yum -y install perl
rpm -qa | grep mariadb  #查询便于下面复制粘贴
#结果为：  mariadb-libs-5.5.64-1.el7.x86_64
rpm -e mariadb-libs-5.5.64-1.el7.x86_64 --nodeps

4、按照mysql的依赖顺序来安装mysql的rpm包

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-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm

到此为止，mysql安装成功

5、查看mysql的服务项是否启动，发现是未启动的

systemctl status mysqld

#● mysqld.service - MySQL Server
#   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
#   Active: inactive (dead)
#     Docs: man:mysqld(8)
#           http://dev.mysql.com/doc/refman/en/using-systemd.html

6、启动服务项，然后再次确认一下

systemctl start mysqld
systemctl status mysqld

#● mysqld.service - MySQL Server
#   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
#   Active: active (running) since 五 2020-05-29 11:25:57 CST; 9s ago
#     Docs: man:mysqld(8)
#           http://dev.mysql.com/doc/refman/en/using-systemd.html

...

7、查询mysql的初始密码(密码保存在/var/log/mysqld.log文件中，此文件是服务项启动后生成的)

cat /var/log/mysqld.log | grep password

8、使用初始密码进行登录

mysql -uroot -p

#输入第7步查询出来的密码

9、登录成功后，要降低密码策略机制，改为low，也可以将密码长度6.

set global validate_password_policy=low;
set global validate_password_length=6;

查看密码策略
show variables like '%validate_password%';

10、修改密码

alter user root@localhost identified by '单引号里新密码';

11、如果想要远程连接mysql，需要进行远程授权操作(注意，一定要关闭防火墙)

grant all privileges on *.* to root@"%" identified by '123456' with grant option;

# 远程授权登录密码可以和本机安装的mysql密码不一样（远程登陆使用远程登陆密码）