下载mysql
yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
安装
yum install mysql-community-server -y
启动MySQL
service mysqld start
查看临时密码
grep 'temporary password' /var/log/mysqld.log
修改密码
alter user user() identified by 'root';
# 查看密码策略
SHOW VARIABLES LIKE 'validate_password%';
# 注意显示的字段 配合下面的操作
validate_password.check_user_name | OFF |
| validate_password.dictionary_file | |
| validate_password.length | 4 |
| validate_password.mixed_case_count | 0 |
| validate_password.number_count | 0 |
| validate_password.policy | LOW |
| validate_password.special_char_count
# 把等级调低
set global validate_password.check_user_name = OFF;
set global validate_password.length = 4;
set global validate_password.mixed_case_count=0;
set global validate_password.number_coun=0;
set global validate_password.special_char_count=0;
允许远程连接
use mysql;
UPDATE user SET host='%' WHERE user='root';
flush privileges;
# vim /etc/my.cnf
[mysqld]
character_set_server = utf8 #设置默认是UTF8 要不创建数据库有默认字符集有乱码
bind-address=0.0.0.0
如果出现错误
Authentication plugin 'caching_sha2_password' cannot be loaded:
以上报错是由于目前已有的客户端连接软件还不支持Mysql8新增加的加密方式caching_sha2_password,所以我们需要修改用户的加密方式,将其改为老的加密验证方式。
大安装Mysql数据库的主机上登录Mysql对应的用户,上面连接时用的用户为root,所以我们登录root用户。
执行命令
use mysql;
select user,plugin from user where user='root';
可以看到当前用户的加密方式为caching_sha2_password
执行命令
alter user 'root'@'%' identified with mysql_native_password by 'Admin@123';
修改防火墙
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload