mysql8 安装

1、下载mysql的repo源（http://repo.mysql.com/） 

wget http://repo.mysql.com/mysql80-community-release-el7.rpm

2、安装rpm包

rpm -ivh mysql80-community-release-el7.rpm

如果之前添加过发生冲突，删除之前的包

检测是否有冲突包：rpm -q mysql80-community-release-el7(冲突包的名称)

删除冲突包： rpm -e mysql80-community-release-el7

 

3、安装mysql

#安装
sudo yum install -y mysql-server mysql-devel
#启动
systemctl start mysqld.service
#查看
systemctl status mysqld

4、修改密码及添加子账号

4.1获取默认密码

#获取默认密码
grep "A temporary password" /var/log/mysqld.log

4.2 修改密码

mysql -u root -p
Enter password: 4.1获取到的默认密码
mysql> alter user 'root'@'localhost' identified by '1111';

mysql8.0.4开始，默认的密码认证插件为caching_sha2_password，当前很多数据库工具和链接包都不支持，为了方便，暂时改为 mysql_native_password

1、#查看mysql配置文件路径

> which mysql
/usr/bin/mysql

> /usr/bin/mysql --verbose --help|grep -A 1 "Default options"
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

#编辑/etc/my.conf, 搜索 default-authentication-plugin进行修改

#登陆mysql 修改密码



2、命令行修改单个用户信息
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '111111';

4.3 添加子账号

#创建账号
create user 'child'@'%' identified with mysql_native_password by 'child123';

#1、授权所有权限
GRANT ALL PRIVILEGES ON 数据库名.* TO 'child'@'%';

#2、授权基本的查询修改权限
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON 数据库名.* TO 'child'@'%';

#查看用户权限
show grants for 'child'@'%';

参考：https://www.cnblogs.com/xiongzaiqiren/p/8970203.html