前置工作,在centos7虚拟机中安装mysql
版本
- 系统:centos7
- mysql:8.0.19
- python: 3.6
- xhsell: 6
创建连接用户
# 查询
mysql> select host,user from user;
+---------------+------------------+
| host | user |
+---------------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+---------------+------------------+
创建一个host为192.168.179.1的root账户;
mysql> create user 'root'@'192.168.179.1' identified by 'abcd1234';
Query OK, 0 rows affected (0.35 sec)
# 可能会提示用户密码不符合密码策略,可以将其直接修改成低强度
mysql> set global validate_password.policy = LOW;
Qu