1. 环境准备
操作系统:centos7.9
MySQL版本:MySQL8.0.26
2. 下载安装包
下载地址: https://downloads.mysql.com/archives/community/
3. 上传安装包
4. 创建目录并解压
[root@DB_MySQL ~]# mkdir -p /mysql [root@DB_MySQL ~]# mv mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar /mysql/ [root@DB_MySQL ~]# tar -xf /mysql/mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar
5. 安装mysql的安装包
cd /mysql/ rpm -qa | grep mariadb mariadb-libs-5.5.68-1.el7.x86_64 rpm -e mariadb-libs-5.5.68-1.el7.x86_64 rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm rpm -ivh mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-8.0.26-1.el7.x86_64.rpm --nodeps --force rpm -ivh mysql-community-libs-compat-8.0.26-1.el7.x86_64.rpm yum install -y openssl-devel rpm -ivh mysql-community-devel-8.0.26-1.el7.x86_64.rpm rpm -ivh mysql-community-client-8.0.26-1.el7.x86_64.rpm rpm -ivh mysql-community-server-8.0.26-1.el7.x86_64.rpm
6. 启动mysql服务
systemctl start mysqld systemctl status mysqld
7. 查询mysql自动生成的密码
grep 'temporary password' /var/log/mysqld.log
命令执行指令
mysql -uroot -p
输入上述查询到的密码,完成登录。
8. 修改root密码
登录MySQL后,将自动生成不方便记忆的密码修改,修改成自己便于记忆的密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '1234';
执行上述SQL后会报错,原因是设置的密码过于简单,密码复杂度不够。我们可以设置密码为简单类型,密码长度为4(生产环境勿动)
set global validate_password.policy = 0; set global validate_password.length = 4;
降低密码规则后,在执行上述命令
9. 创建远程登录账户
默认的root用户只能当前节点localhost访问,是无法远程访问的,我们还需要创建一个root账户,用户远程访问
create user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '1234';
10. 授权
grant all on *.* to 'root'@'%';