1 下载mysql

官网地址：https://downloads.mysql.com/archives/community/

2 安装mysql

# 创建文件夹
mkdir mysql8
# 上传到mysql8文件夹中, 解压文件夹
tar -xvf mysql-8.1.0-1.el7.x86_64.rpm-bundle.tar
# 依次安装rpm文件
rpm -ivh mysql-community-common-8.0.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-plugins-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

yum install net-tools  #安装mysql-community-server前需要安装好的组件

rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm

3 修改mysql配置

# 设置复杂密码
ALTER USER USER() IDENTIFIED BY '复杂密码';

# 调整设置密码策略
set global validate_password.policy=0;
# 调整设置密码长度
set global validate_password.length=1;

# 设置简单密码
ALTER USER USER() IDENTIFIED BY '简单密码';

#开启访问权限：
# 1.创建用户root，密码123456
create USER 'root'@'%' IDENTIFIED BY '123456';
flush privileges; #刷新

# 2.给用户授权
grant all privileges on *.* to 'root'@'%';
flush privileges; #刷新

#指定数据库
grant all privileges on 想授权的数据库.* to '用户名'@'%';
FLUSH PRIVILEGES;
#全部数据库
grant all privileges on *.* to '用户名'@'%';
FLUSH PRIVILEGES;

# 删除指定数据库的权限权限
REVOKE ALL PRIVILEGES ON testdb.* FROM 'testuser'@'%';
FLUSH PRIVILEGES;

# 删除所有的数据库权限
REVOKE ALL PRIVILEGES ON *.* FROM 'testuser'@'%';
FLUSH PRIVILEGES;

# 这里就需要修改root密码，如果不修改，密码就会被改为password
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;

# 密码与上一个命令保持一致
ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password BY '123456';

flush privileges; #刷新

4 问题以及解决方案

yum remove mysql-libs
# 后续再次安装libs包即可

yum install net-tools
yum install -y perl-Module-Install.noarch
然后进行安装
rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm

MySQL 常用命令

# 启动
systemctl start mysqld

# 第一次启动后，可以查看mysql初始化密码
grep 'temporary password' /var/log/mysqld.log

# 重启
systemctl restart mysqld

# 停止
systemctl stop mysqld

#查看状态
systemctl status mysqld

#开机启动
systemctl enable mysqld
systemctl daemon-reload

# 查看进程、版本信息
ps -ef | grep mysql
或
netstat -atp

# 登录
mysql -u root -p'密码内容'

# 查看所有表
show databases;

# 进入数据库
use 表名

# 查看所有表
show tables

# 查看某张表信息
desc 表名

# 查
select * from 表名
# 删
delete from 表名 where field=xx
# 改
update 表名 set field='xxx' where field='xxx';