Centos7安装Mysql8.0.32

Centos7安装Mysql8.0.32

一.检测是否安装mariadb

rpm -qa | grep -i mariadb

移除mysql相关依赖包

rpm -ev --nodeps 检索出来的文件

二.下载并安装

1.下载rpm包

https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.32-1.el7.x86_64.rpm-bundle.tar

2.上传至服务器并解压

tar -xvf mysql-8.0.32-1.el7.x86_64.rpm-bundle.tar

解压内容

mysql-community-client-8.0.32-1.el7.x86_64.rpm
mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm
mysql-community-common-8.0.32-1.el7.x86_64.rpm
mysql-community-debuginfo-8.0.32-1.el7.x86_64.rpm
mysql-community-devel-8.0.32-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.32-1.el7.x86_64.rpm
mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm
mysql-community-libs-8.0.32-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.32-1.el7.x86_64.rpm
mysql-community-server-8.0.32-1.el7.x86_64.rpm
mysql-community-server-debug-8.0.32-1.el7.x86_64.rpm
mysql-community-test-8.0.32-1.el7.x86_64.rpm

3.安装mysql

rpm -ivh mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm 
rpm -ivh mysql-community-common-8.0.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm

4.启动mysql

systemctl start mysqld

5.查看mysql运行状态

systemctl status mysqld

6.设置开机自启

systemctl enable mysqld
systemctl daemon-reload

三.登录并修改密码

1.获取临时登录密码

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

2.登录mysql

mysql -u root -p

3.修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';

4.授权远程登录

use mysql;
update user set host='%' where user ='root';
flush privileges;

四.忘记密码

1.修改 /etc/my.cnf文件 跳过密码验证

vi /etc/my.cnf
##文件末尾添加
skip-grant-tables
# 重启mysql
systemctl restart mysqld

2.进入mysql 清空登录密码

#终端输入mysql
use mysql;
update user set authentication_string='' where user='root';
quit;

3.恢复配置文件并登录

3.1).恢复配置文件

vi /etc/my.cnf
#删除skip-grant-tables
#重启mysql
systemctl restart mysqld

3.2)登录mysql并修改密码

mysql -uroot  -p
#输入密码时直接回车
#修改密码
ALTER USER 'root'@'%' IDENTIFIED BY 'new password';
flush privileges;
quit;

3.3)重启mysql

systemctl restart mysql