Centos yum 安装 mysql8以及安全策略

需求

Centos yum 安装 mysql8 需要用到的命令

内容

wget http://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

yum -y install mysql80-community-release-el8-1.noarch.rpm


yum module disable mysql
yum install mysql-community-server

systemctl status mysqld.service
systemctl enable mysqld.service
systemctl start mysqld.service

更新密码：

跳过权限验证
vim /etc/my.cnf 添加 skip-grant-tables 然后重启mysql
记得最后去掉

进入mysql

use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Hkfdh&823@kfsjd';
# 使用老版本验证方式，不实用最新的caching_sha2_password

安全

创建新账号赋予root权限

CREATE USER 'syhy'@'%' IDENTIFIED WITH mysql_native_password BY 'adsfJ88^&KJ';
GRANT ALL PRIVILEGES ON *.* TO 'syhy'@'%' WITH GRANT OPTION;
flush privileges;

mysql降权

修改/etc/my.cnf

# 确保MySQL运行用户为一般用户
user=mysql
# 修改默认端口
port=3587 #default 3306