8.2-配置mysql环境

安装mysql

1.下载安装包

[root@mysql2 ~]# wget https://downloads.mysql.com/archives/[get](https://so.csdn.net/so/search?q=get&spm=1001.2101.3001.7020)/p/23/file/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar 

2.解压

[root@mysql2 ~]# tar -xf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar 

3.卸载mariadb

[root@mysql2 ~]#yum -y remove mariadb

4.安装依赖包

#直到安装好mysql-community-server-8.0.33-1.el7.x86_64.rpm为止  [root@mysql2 ~]# rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm  警告：mysql-community-server-8.0.33-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY 错误：依赖检测失败： 	mysql-community-client(x86-64) >= 8.0.11 被 mysql-community-server-8.0.33-1.el7.x86_64 需要 	mysql-community-common(x86-64) = 8.0.33-1.el7 被 mysql-community-server-8.0.33-1.el7.x86_64 需要 	mysql-community-icu-data-files = 8.0.33-1.el7 被 mysql-community-server-8.0.33-1.el7.x86_64 需要  [root@mysql2 ~]# rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm  警告：mysql-community-server-8.0.33-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY 准备中...                          ################################# [100%] 正在升级/安装...    1:mysql-community-server-8.0.33-1.e################################# [100%]

5.初始化配置mysql

[root@mysql2 ~]#mysqld --initialize

6.修改/etc/my.cnf配置文件

#启动服务出现错误 [root@mysql2 ~]# vim /etc/my.cnf #添加内容 explicit_defaults_for_timestamp=true #强制、递归地删除 /var/lib/mysql/目录下的所有文件和子目录  [root@mysql2 ~]# rm -rf /var/lib/mysql/*

7.启动服务

[root@mysql2 ~]# systemctl start mysqld

8.设置开机启动mysql服务

[root@mysql2 ~]#systemctl start mysqld.service

9.获得初始密码

[root@mysql2 ~]# cat /var/log/mysqld.log|grep password

10.使用初始密码登录

[root@mysql2 ~]# mysql -uroot -p Enter password: Rej+/6tQ#5LW

11.重新设置密码

mysql>  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Hui@2003';

12.远程修改权限

mysql> create user 'root'@'%'identified with mysql_native_password by 'Hui@2003'; mysql> grant all privileges on *.* to 'root'@'%' with grant option;

13.刷新

mysql> flush privileges;