centos7安装mysql

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

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

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

yum -y localinstall mysql-community-release-el6-5.noarch.rpmyum -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密码不一样（远程登陆使用远程登陆密码）