{"id":1401,"date":"2020-05-25T18:36:05","date_gmt":"2020-05-25T10:36:05","guid":{"rendered":"http:\/\/39.97.231.10\/?p=1401"},"modified":"2020-05-25T18:36:05","modified_gmt":"2020-05-25T10:36:05","slug":"mysql%e6%8a%a5%e9%94%99error-1819-hy000-your-password-does-not-satisfy-the-current-policy-requirements","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=1401","title":{"rendered":"MySQL\u62a5\u9519ERROR 1819 (HY000): Your password does not satisfy the current policy requirements"},"content":{"rendered":"<p>MySQL\u62a5\u9519\u201cERROR 1819 (HY000): Your password does not satisfy the current policy requirements\u201d<\/p>\n<div>\n<div>\n<h3>\u89e3\u51b3\u529e\u6cd5\uff1a<\/h3>\n<ul>\n<li><strong>\u67e5\u770b mysql \u521d\u59cb\u7684\u5bc6\u7801\u7b56\u7565\u3002<\/strong><\/li>\n<\/ul>\n<pre>mysql&gt; show variables like \\'validate_password%\\';\n+--------------------------------------+--------+\n| Variable_name                        | Value  |\n+--------------------------------------+--------+\n| validate_password_check_user_name    | OFF    |\n| validate_password_dictionary_file    |        |\n| validate_password_length             | 8      |\n| validate_password_mixed_case_count   | 1      |\n| validate_password_number_count       | 1      |\n| validate_password_policy             | MEDIUM |\n| validate_password_special_char_count | 1      |\n+--------------------------------------+--------+\n7 rows in set (0.00 sec)<\/pre>\n<div class=\\\"image-package\\\">\n<ul>\n<li class=\\\"image-view\\\" data-width=\\\"963\\\" data-height=\\\"274\\\"><strong>\u8bbe\u7f6e\u5bc6\u7801\u9a8c\u8bc1\u5f3a\u5ea6\u7b49\u7ea7\uff0c\u5c06MEDIUM\u8bbe\u7f6e\u4e3aLOW\u3002<\/strong><\/li>\n<\/ul>\n<pre data-width=\\\"963\\\" data-height=\\\"274\\\">mysql&gt; set global validate_password_policy=LOW;\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n<\/div>\n<div class=\\\"image-package\\\">\n<div class=\\\"image-container\\\">\n<ul>\n<li class=\\\"image-view\\\" data-width=\\\"972\\\" data-height=\\\"328\\\"><strong>\u4fee\u6539\u5bc6\u7801\u9ed8\u8ba4\u957f\u5ea6\u4e3a6<\/strong><\/li>\n<\/ul>\n<\/div>\n<pre data-width=\\\"972\\\" data-height=\\\"328\\\">mysql&gt; set global validate_password_length=6;\nQuery OK, 0 rows affected (0.01 sec)<\/pre>\n<\/div>\n<p>\u73b0\u5728\u53ea\u8981\u6ee1\u8db3\u516d\u4f4d\u7684\u957f\u5ea6\u7684\u7b80\u5355\u5bc6\u7801\u5373\u53ef\u8bbe\u7f6e\n<\/p><\/div>\n<pre><b>ALTER USER \\'root\\'@\\'localhost\\' IDENTIFIED BY \\'123456\\';<\/b><\/pre>\n<div>\n<div class=\\\"image-package\\\">\n<div class=\\\"image-container\\\">\n<div class=\\\"image-view\\\" data-width=\\\"952\\\" data-height=\\\"326\\\"><\/div>\n<\/div>\n<\/div>\n<ul>\n<li><strong>\u5173\u4e8e mysql \u5bc6\u7801\u7b56\u7565\u76f8\u5173\u53c2\u6570\uff1b<\/strong><\/li>\n<li>validate_password_length \u00a0\u56fa\u5b9a\u5bc6\u7801\u7684\u603b\u957f\u5ea6\uff1b<\/li>\n<li>validate_password_dictionary_file \u6307\u5b9a\u5bc6\u7801\u9a8c\u8bc1\u7684\u6587\u4ef6\u8def\u5f84\uff1b<\/li>\n<li>validate_password_mixed_case_count \u00a0\u6574\u4e2a\u5bc6\u7801\u4e2d\u81f3\u5c11\u8981\u5305\u542b\u5927\/\u5c0f\u5199\u5b57\u6bcd\u7684\u603b\u4e2a\u6570\uff1b<\/li>\n<li>validate_password_number_count \u00a0\u6574\u4e2a\u5bc6\u7801\u4e2d\u81f3\u5c11\u8981\u5305\u542b\u963f\u62c9\u4f2f\u6570\u5b57\u7684\u4e2a\u6570\uff1b<\/li>\n<li>validate_password_policy \u6307\u5b9a\u5bc6\u7801\u7684\u5f3a\u5ea6\u9a8c\u8bc1\u7b49\u7ea7\uff0c\u9ed8\u8ba4\u4e3a MEDIUM\uff1b<\/li>\n<li>\u5173\u4e8e validate_password_policy \u7684\u53d6\u503c\uff1a<\/li>\n<\/ul>\n<\/div>\n<div>\n<pre style=\\\"padding-left: 40px;\\\">0\/LOW\uff1a\u53ea\u9a8c\u8bc1\u957f\u5ea6\uff1b\n1\/MEDIUM\uff1a\u9a8c\u8bc1\u957f\u5ea6\u3001\u6570\u5b57\u3001\u5927\u5c0f\u5199\u3001\u7279\u6b8a\u5b57\u7b26\uff1b\n2\/STRONG\uff1a\u9a8c\u8bc1\u957f\u5ea6\u3001\u6570\u5b57\u3001\u5927\u5c0f\u5199\u3001\u7279\u6b8a\u5b57\u7b26\u3001\u5b57\u5178\u6587\u4ef6\uff1b<\/pre>\n<ul>\n<li>validate_password_special_char_count \u6574\u4e2a\u5bc6\u7801\u4e2d\u81f3\u5c11\u8981\u5305\u542b\u7279\u6b8a\u5b57\u7b26\u7684\u4e2a\u6570\u3002<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\u62a5\u9519\u201cERROR 1819 (HY000): Your password does not sati &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"http:\/\/www.weijing.co\/?p=1401\"> <span class=\"screen-reader-text\">MySQL\u62a5\u9519ERROR 1819 (HY000): Your password does not satisfy the current policy requirements<\/span> \u67e5\u770b\u5168\u6587 &raquo;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[90],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"mailpoet_newsletter_max":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false,"shop_catalog":false,"shop_single":false,"shop_thumbnail":false},"uagb_author_info":{"display_name":"weijing","author_link":"http:\/\/www.weijing.co\/?author=4"},"uagb_comment_info":0,"uagb_excerpt":"MySQL\u62a5\u9519\u201cERROR 1819 (HY000): Your password does not sati&hellip;","_links":{"self":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/1401"}],"collection":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1401"}],"version-history":[{"count":0,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/1401\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1401"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}