Mysql 8.0 简单密码,root远程登陆
你好世界
mysql> show variables like ‘%password%’; —查看mysql 管理策略
±---------------------------------------------±----------------+
| Variable_name | Value |
±---------------------------------------------±----------------+
| caching_sha2_password_auto_generate_rsa_keys | ON |
| caching_sha2_password_private_key_path | private_key.pem |
| caching_sha2_password_public_key_path | public_key.pem |
| default_password_lifetime | 0 |
| disconnect_on_expired_password | ON |
| generated_random_password_length | 20 |
| mysql_native_password_proxy_users | OFF |
| password_history | 0 |
| password_require_current | OFF |
| password_reuse_interval | 0 |
| report_password | |
| sha256_password_auto_generate_rsa_keys | ON |
| sha256_password_private_key_path | private_key.pem |
| sha256_password_proxy_users | OFF |
| sha256_password_public_key_path | public_key.pem |
| 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 |
±---------------------------------------------±----------------+
mysql> set GLOBAL validate_password.check_user_name=OFF; 校验用户名和密码,比如密码不能为 root
Query OK, 0 rows affected (0.00 sec)
mysql> set GLOBAL validate_password.length=4; 密码长度
Query OK, 0 rows affected (0.00 sec)
mysql> set GLOBAL validate_password.mixed_case_count=0; 密码中至少要包含大/小写字母的总个数
Query OK, 0 rows affected (0.00 sec)
mysql> set GLOBAL validate_password.number_count=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set GLOBAL validate_password.policy=LOW;
Query OK, 0 rows affected (0.00 sec)
mysql> set GLOBAL validate_password.special_char_count=0;
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘root’; 本地权限
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE USER ‘root’@’%’ IDENTIFIED BY ‘root’; 创建root 远程用户,这块神奇吧
mysql> GRANT ALL ON . TO ‘root’@’%’ WITH GRANT OPTION; 权限
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)