离线安装MySQL8

一、安装MySQL

1、从官网下载MySQL8安装包

https://dev.mysql.com/downloads/mysql/

先使用cat /proc/version查看系统版本，让后根据试图选择

2、将下载好的安装包上传至服务器上

3、删除原有的mysql和mariadb

rpm -qa|grep mysql
rpm -qa|grep mariadb

将查看到的使用rpm -e --nodeps删除
如：rpm -e --nodeps mysql-community-client-plugins

4、解压并安装MySQL

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

逐个安装rpm包，注意安装顺序

rpm -ivh mysql-community-common-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.27-1.el7.x86_64.rpm

5、查看服务状态

systemctl status mysqld

此时MySQL服务尚未启动，先进行数据库初始化操作，输入以下命令：

mysqld --initialize --console

再授权目录：

chown -R mysql:mysql /var/lib/mysql/

6、启动MySQL服务

systemctl start mysqld

查看此时MySQL服务的状态：

systemctl status mysqld

MySQL已启动！

7、修改MySQL登录

直接使用忘记密码的方法

vim /etc/my.cnf
skip-grant-tables    #添加无密码登录
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

然后登录MySQL

mysql -uroot -p       #无需输入密码，直接回车即可。

切换到mysql，将密码置空:

use mysql;
update user set authentication_string='' where user='root';

然后刷新权限:

flush privileges;

设置加密规则并更新新密码设置远程连接，授权(直接复制这些SQL语句你的密码会更新为123456)

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; 
alter user 'root'@'localhost' identified by '123456';
grant all privileges  on *.*  to "root"@'localhost';
update user set host='%' where user='root';
flush privileges;

设置成功后，进入my.cnf删除刚才添加的skip-grant-tables,重启mysql服务，使用新密码登录

systemctl stop mysqld
systemctl start mysqld

使用Navicat for MySQL连接即可