Centos7.5 && Mysql8.0

安装

mysql community server 选择系统后下载rpm建议下载RPM bundle 以免依赖不够

步骤如下
解压

tar -zxvf mysql-8.0.29-1.el7.x86_64.rpm-bundle.tar

安装

rpm -ivh mysql-community-common-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm
yum install libaio -y
yum install net-tools -y
rpm -ivh mysql-community-server-8.0.29-1.el7.x86_64.rpm
总之提示缺什么依赖就按什么依赖，注意 clilent，server 是需要的

检查rpm 安装的mysql 包

rpm -qa | grep mysql

删除rpm 包

rpm -e xxx

启动服务

systemctl start mysqld

查看临时密码

cat /var/log/mysqld.log | grep password

进入mysql

mysql -uroot -p

修改root密码

alter user 'root'@'localhost' identified by '[userpassword]';

修改mysql的密码安全策略

show variables like 'validate_password%';
set global validate_password.policy=LOW;
set global validate_password.length=6;

用户管理

一般mysql的root用户不对外部IP开辟访问权限，一般安装mysql后通过root用户创建新的用户并授予相应的权限

查看当前已有的mysql用户

use mysql;
select Host, Name from user;

创建用户

create user '[username]'@'[ip]' identified by '[password]';
# 例如
create user ‘admin’@'%' identified by '123456';
create user 'admin'@‘10.0.0.%’ identified by '123456'    #指定用户的访问网段
create user 'admin'@'10.0.0.100' identified by '123456'  #指定用户的访问IP

删除用户

drop user 'username'@‘ip’;

修改用户

rename user 'username'@'ip' to 'newusername'@'newip';
set password for 'username'@'ip'=Password('newpassword');

权限管理

查看权限

show grants for 'user'@'ip';

授予权限

#为用户授予db数据库下所有表的查，增，改权限
grant select, insert, update on db.* to 'user'@'ip'; 
#为用户授予所有数据库下所有表的所有权限
grant all privileges on *.* to 'user'@'ip' 

冻结权限

revoke all on db.* from 'user'@'ip';
revoke all privileges on *.* from 'user'@'ip';