Centos7.5 使用yum安装 mysql8.0
配置yum仓库:
cd /etc/yum.repos.d/
yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
yum clean # 清理yum缓存
yum update # 更新yum仓库
安装mysql8.0:
yum install mysql-community-server
启动mysql:
service mysqld start #启动数据库
systemctl status mysqld # 查看启动状态
查看数据库初始密码:
cat /var/log/mysqld.log | grep localhost
登录数据库:
mysql -uroot -p
修改数据库root密码
alter user 'root'@'localhost' identified by '12345678';
flush privileges; #修改后刷新
修改密码报错处理:
查看密码修改规则:
show variables like 'validate_password%';
使用命令进行修改改密码规则:
set global validate_password_length=8; #修改密码长度
set global validate_password_policy=LOW; #开启登录只验证密码长度
数据库账户授权:
use mysql;
update user set host='%' where user ='root'; #允许任意ip访问本机数据库
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION; # 允许root用户所有权限
PRIVILEGES ON . TO ‘root’@’%'WITH GRANT OPTION; # 允许root用户所有权限