1、下载rpm文件:地址是https://dev.mysql.com/downloads/mysql/
2、下载四个文件:(选择对应的版本)
(mysql-community-server-5.7.29-1.el7.x86_64.rpm)
(mysql-community-client-5.7.29-1.el7.x86_64.rpm)
(mysql-community-common-5.7.29-1.el7.x86_64.rpm)
(mysql-community-libs-5.7.29-1.el7.x86_64.rpm)
3、执行命令安装
如果存在冲突或者缺少依赖:卸载: rpm -e --nodeps mysql-community-common-8.0.19-1.el7.x86_64
rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm
到这里默认就安装结束,同时已经启动mysql的服务
4、查看mysql运行状态,并重启
systemctl status mysqld
systemctl restart mysqld
5、重置密码
5.1:vim /etc/my.cnf
5.2:在最后加上: skip-grant-tables
5.3:重启mysql服务: systemctl restart mysqld
5.4: mysql -u root-p 不需要输入密码直接enter即可
5.5:设置root账号的密码:
设置密码:update mysql.user set authentication_string=password('123456') where user='root' ;
刷新:FLUSH PRIVILEGES;
5.6:退出mysql:将之前加入的跳过密码验证删掉
命令:vim /etc/my.cnf
把skip-grant-tables去掉
5.7: 重新登录数据库
执行命令出现不能操作情况:show databases;
修改密码即可:alter user 'root'@'localhost' identified by 'Root123.@';
5.8:外部不能连接问题
use mysql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Root123.@' WITH GRANT OPTION;
flush privileges;刷新