在安装前先看系统中是否安装了mariadb,如果有,需要先卸载了在进行安装mysql
rpm -qa|grep mariadb
卸载mariadb
rpm -e mariadb-libs-5.5.64-1.el7.x86_64
如果有依赖,卸载不掉,可以强制卸载
rpm -e mariadb-libs-5.5.64-1.el7.x86_64 --nodeps
先对mysql的安装包进行解压
1.安装 mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
2.安装mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
3.安装mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
4.安装 mysql-community-server-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
执行这条命令的时候出现了错误
警告:mysql-community-server-5.7.28-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误:依赖检测失败:
/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 需要
错误的原因就是没有安装perl
yum -y install perl.x86_64
安装完成以后再执行
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
mysql的使用
1.启动mysql的服务
systemctl start mysqld
查看mysqld状态
systemctl status mysqld
2.登录到mysql
第一次开启mysql的时候会生成一次随机的密码,查看mysql的密码
grep password /var/log/mysqld.log
2021-06-27T14:47:07.772561Z 1 [Note] A temporary password is generated for root@localhost: SlpypxZbX8
SlpypxZbX8
3.登录mysql
mysql -uroot -p
输入密码
SlpypxZbX8
4.修改mysql的安全等级
修改密码策略等级为LOW
set global validate_password_policy=LOW;
设置密码的最短长度
set global validate_password_length=4;
设置密码中最少有0个大写字母或是小写字母
set global validate_password_mixed_case_count=0;
设置密码中最少有0个数字
set global validate_password_number_count=0;
设置密码中最少有0个特殊字符
set global validate_password_special_char_count=0;
5修改密码,修改密码为123456
alter user root@localhost identified by '123456';
6.远程授权
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
7.本地的mysql可视化工具可以通过虚拟机中ip的地址进行连接