mysql的安装

mysql 5.7.28 rpm离线 安装方法

首先下载对应的压缩包
链接：https://pan.baidu.com/s/1uBK5qg0-z8ce4C551rWsJQ
提取码：1gxt
–来自百度网盘超级会员V4的分享
1.检查系统自带的MySQL及相关RPM包，是否安装
rpm -qa | grep -i mysql
2.解压压缩包 tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
3.安装perl依赖 yum install -y perl net-tools
4.卸载Centos 捆绑的mariadb-libs
rpm -qa|grep mariadb
rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps
5.依次执行下列命令执行MySQL安装包
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
6.修改MySQL文件夹权限
chmod -R 777 /var/lib/mysql/
7.初始化MySQL
mysqld --initialize
chmod -R 777 /var/lib/mysql/*
8.启动mysqld服务
systemctl start mysqld
9.查看日志，日志里面有启动信息和初始化密码
cat /var/log/mysqld.log
cat /var/log/mysqld.log|grep “password”

这是我的密码
10.登录mysql -uroot -pxivbiZG&R8YM
使用临时密码即可，
修改成自己想要的密码：update user set authentication_string = password(“123456”) where user=‘root’;
之后执行mysql退出:quit;

注意问题:
1.在登录密码的时候一般都会出现问题所以需要走配置
vim /etc/my.cnf
![在这里插入图片描述](https://img-blog.csdnimg.cn/8397c851c8c0485fb9f35167f069dce8.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAc3VuX2xpYW5TaHVhbmc=,size_20,color_FFFFFF,t_70,g_se,x_16
把这个注解解开或者加上skip-grant-tables即可
这时候重启mysqld
systemctl stop mysqld
systemctl start mysqld

登录mysql -uroot
修改初始密码update user set authentication_string = password(“123456”) where user=‘root’;

vim /etc/my.cnf里面的skip-grant-tables注释
重启mysqld
systemctl stop mysqld
systemctl start mysqld
就可以登录了 mysql -uroot -p123456

2.cat /var/log/mysqld.log
如果出现
[Warning] Found invalid password for user: ‘root@localhost’; Ignoring user
除非彻底卸载，这又是很麻烦的事情。
这时候只需先停掉服务，然后删除掉/var/lib/mysql目录：
$ sudo rm -rf /var/lib/mysql

之后按照上面修改密码的方法即可

3.如果出现下面这个错误
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
执行alter user user() identified by “245354”;
如果执行上面语句报错
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
执行set global validate_password_policy=LOW;
set global validate_password_length=6;
即可

关闭防火墙命令:
systemctl stop iptables
systemctl stop firewalld
systemctl disable firewalld.service