创建xtrbackup备份用户 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

查看密码策略

1
2
3
4
5
6
7
8
9
10
11
12
13
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)

  修改策略

1
2
3
4
5
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
 
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)

  创建备份用户

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
创建用户
mysql> create user 'bk'@'%' IDENTIFIED by 'ocm123';
Query OK, 0 rows affected (0.01 sec)
授权
mysql> grant RELOAD,LOCK TABLES,REPLICATION CLIENT,PROCESS,SUPER,CREATE,INSERT,SELECT on *.* to bk@'%';
Query OK, 0 rows affected, 1 warning (0.01 sec)
查看权限
mysql> show grants for bk@'%';
+----------------------------------------------------------------------------------------------------------+
| Grants for bk@%                                                                                          |
+----------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, CREATE, RELOAD, PROCESS, SUPER, LOCK TABLES, REPLICATION CLIENT ON *.* TO `bk`@`%` |
+----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
简单粗暴点
grant all on *.* to bk@'%';

  

posted @   刚好遇见Mysql  阅读(8)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
历史上的今天:
2023-08-02 1209 - The MySQL server is running with the--read-only option so it cannot execute this statement
2021-08-02 oracle批量安装时最新19Cpsu集成
2018-08-02 ebs 12.1.1打中文补丁
点击右上角即可分享
微信分享提示