一、安装前准备
1.下载并安装MySQL Yum Repository
wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
rpm -ihv mysql80-community-release-el7-3.noarch.rpm
二、安装MySQL8.0
安装的MySQL Commuity Server,安装快慢是网络情况而定。
安装:sudo yum install -y mysql-community-server
启动Mysqld服务:sudo service mysqld start
查看Mysqld服务:sudo service mysqld status
查看临时密码:sudo grep 'temporary password' /var/log/mysqld.log
如果没有临时密码,生成一个临时密码:mysqld --initialize --user=mysql --console
三、修改MySQL8.0的临时密码
密码需要符合以下要求,除非修改密码规则。
mysql> SHOW VARIABLES LIKE 'validate_password%';
+----------------------------------------------------+----------+
| Variable_name | Value |
+----------------------------------------------------+----------+
| validate_password.check_user_name | ON |
| validate_password.dictionary_file | |
| validate_password.length | 8 |
| validate_password.mixed_case_count | 1 |
| validate_password.number_count | 1 |
| validate_password.policy | MEDIUM |
| validate_password.special_char_count | 1 |
+----------------------------------------------------+----------+
7 rows in set (0.01 sec)
修改MySQL 8.0密码验证规则:
mysql> set global validate_password.policy=0;
mysql> set global validate_password.length=1;
修改密码:alter USER 'root'@'localhost' IDENTIFIED BY 'PAN1997.com'
四、配置MySQL8.0
远程连接:https://blog.csdn.net/pannubi/article/details/104861672
创建一个用于远程连接的用户:create user 'nubipan'@'%' identified by "PAN1997.com";
查看用户的权限 show grants for 'nubipan'@'%';
+----------------------------------------------------------+
| Grants for nubipan@% |
+----------------------------------------------------------+
| GRANT USAGE ON *.* TO `nubipan`@`%` |
+----------------------------------------------------------+
1 row in set (0.00 sec)
#可根据自身情况对用户进行赋予权限
mysql> grant all privileges on * to 'nubipan'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
远程连接已经配置完成,此时需要将3306端口开放。
#iptables为CentOS6的防火墙使用方式,CentOS7使用的是firewall。
#iptables
sudo iptables -A input -p --dport 3306 -j ACCEPT
sudo systemctl restart iptables.service
#firewall 方式
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重启防火墙
firewall-cmd --reload