{"id":1346,"date":"2019-07-05T16:56:11","date_gmt":"2019-07-05T13:56:11","guid":{"rendered":"https:\/\/artem.services\/?p=1251"},"modified":"2019-08-01T15:27:22","modified_gmt":"2019-08-01T12:27:22","slug":"1346","status":"publish","type":"post","link":"https:\/\/artem.services\/?p=1346&lang=en","title":{"rendered":"\u00a0FIX ERROR &#8212; MySQL: Your password does not satisfy the current policy requirements"},"content":{"rendered":"<p><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">When trying to set a password for the <strong>mysql<\/strong> user, the following error occurs:<\/span><\/span><\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">This error appears if your password does not meet the following requirements, for &quot;<strong>validate_password.policy<\/strong>&quot; in &quot;<strong>MEDIUM<\/strong>&quot; mode it is:<\/span><\/span><\/p>\n<ul>\n<li><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">Minimum length 8 characters<\/span><br \/>\n<\/span><\/li>\n<li><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">At least one digit<\/span><br \/>\n<\/span><\/li>\n<li><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">At least one uppercase letter<\/span><br \/>\n<\/span><\/li>\n<li><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">At least one special character<\/span><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>Solution:<\/h3>\n<p>1. <span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Set a password that meets the security requirements for passwords.<\/span><\/span><\/p>\n<p>2. <span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Or lower the password security requirement level:<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">If the second option suits you, then log in to <strong>mysql<\/strong> and look at the current value:<\/span><\/span><\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nmysql&amp;gt; SHOW VARIABLES LIKE 'validate_password%';\r\n+--------------------------------------+--------+\r\n| Variable_name                        | Value  |\r\n+--------------------------------------+--------+\r\n| validate_password.check_user_name    | ON     |\r\n| validate_password.dictionary_file    |        |\r\n| validate_password.length             | 8      |\r\n| validate_password.mixed_case_count   | 1      |\r\n| validate_password.number_count       | 1      |\r\n| validate_password.policy             | MEDIUM |\r\n| validate_password.special_char_count | 1      |\r\n+--------------------------------------+--------+\r\n7 rows in set (0.00 sec)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">And lower the level:<\/span><\/span><\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nSET GLOBAL validate_password.policy=LOW;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>When trying to set a password for the mysql user, the following error occurs: &nbsp; This error appears if your password does not meet the following requirements, for &quot;validate_password.policy&quot; in &quot;MEDIUM&quot; mode it is: Minimum length 8 characters At least one digit At least one uppercase letter At least one special character &nbsp; Solution: 1. &hellip; <a href=\"https:\/\/artem.services\/?p=1346&#038;lang=en\" class=\"more-link\">\u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0438\u0442\u044c \u0447\u0438\u0442\u0430\u0442\u044c<span class=\"screen-reader-text\"> &quot;\u00a0FIX ERROR &#8212; MySQL: Your password does not satisfy the current policy requirements&quot;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[357],"tags":[361,365,481,1071],"_links":{"self":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/1346"}],"collection":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1346"}],"version-history":[{"count":2,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/1346\/revisions"}],"predecessor-version":[{"id":1350,"href":"https:\/\/artem.services\/index.php?rest_route=\/wp\/v2\/posts\/1346\/revisions\/1350"}],"wp:attachment":[{"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/artem.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}