{"id":38237,"date":"2019-03-19T10:49:46","date_gmt":"2019-03-19T10:49:46","guid":{"rendered":"http:\/\/systemadmin.es\/?p=5132"},"modified":"2019-03-19T10:49:46","modified_gmt":"2019-03-19T10:49:46","slug":"mysql-your-password-does-not-satisfy-the-current-policy-requirements","status":"publish","type":"post","link":"https:\/\/icloud.pe\/blog\/mysql-your-password-does-not-satisfy-the-current-policy-requirements\/","title":{"rendered":"MySQL: Your password does not satisfy the current policy requirements"},"content":{"rendered":"<p>Mediante el plugin <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/validate-password.html\">validate_password<\/a> podemos definir unos requisitos minimos de seguridad para las contrase\u00f1as de <strong>MySQL<\/strong>:<\/p>\n<pre>\r\nmysql&gt; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `dbdemo`.* TO 'demouser'@'%' identified by 'demopassword';\r\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\r\nmysql&gt; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `dbdemo`.* TO 'demouser'@'1.2.3.4' identified by 'demopassword';\r\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\r\n<\/pre>\n<p>Evidentemente para ciertos entornos dicho plugin puede resultar un problema por lo que podemos querer desactivarlo.<\/p>\n<p><!-- more --><\/p>\n<p>Podemos desactivar el plugins mediante el siguiente comando:<\/p>\n<pre>\r\nmysql&gt; uninstall plugin validate_password;\r\nQuery OK, 0 rows affected (0.04 sec)\r\n<\/pre>\n<p>A continuaci\u00f3n los password ya no ser\u00e1n examinados con los criterios m\u00ednimos de seguridad:<\/p>\n<pre>\r\nmysql&gt; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `dbdemo`.* TO 'demouser'@'%' identified by 'demopassword';\r\nQuery OK, 0 rows affected, 1 warning (0.06 sec)\r\n\r\nmysql&gt; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `dbdemo`.* TO 'demouser'@'1.2.3.4' identified by 'demopassword';\r\nQuery OK, 0 rows affected, 1 warning (0.01 sec)\r\n<\/pre>\n<p>\tTags: <a href=\"http:\/\/systemadmin.es\/tag\/mysql\" title=\"MySQL\" rel=\"tag\">MySQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mediante el plugin validate_password podemos definir unos requisitos minimos de seguridad para las contrase&ntilde;as de MySQL: mysql&gt; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `dbdemo`.* TO &#8216;demouser&#8217;@&#8217;%&#8217; identified by &#8216;demopassword&#8217;; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements mysql&gt; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, [&hellip;]<\/p>\n","protected":false},"author":321,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5052,523],"tags":[],"class_list":["post-38237","post","type-post","status-publish","format-standard","hentry","category-dba","category-mysql"],"_links":{"self":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/38237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/users\/321"}],"replies":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/comments?post=38237"}],"version-history":[{"count":2,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/38237\/revisions"}],"predecessor-version":[{"id":41901,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/38237\/revisions\/41901"}],"wp:attachment":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/media?parent=38237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/categories?post=38237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/tags?post=38237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}