{"id":556,"date":"2011-09-23T09:13:29","date_gmt":"2011-09-23T15:13:29","guid":{"rendered":"http:\/\/vostorga.org\/?p=556"},"modified":"2011-09-23T09:15:09","modified_gmt":"2011-09-23T15:15:09","slug":"error-1396-hy000-operation-create-user-failed","status":"publish","type":"post","link":"https:\/\/vostorga.org\/?p=556","title":{"rendered":"ERROR 1396 (HY000): Operation CREATE USER failed"},"content":{"rendered":"<p>MySQL puede ser un poco delicado al momento de manipular usuarios. Al intentar crear un usuario, el cual yo sab\u00eda que existi\u00f3 en alg\u00fan momento, me devolvi\u00f3 el error 1396<\/p>\n<blockquote>\n<pre>mysql&gt; CREATE USER 'foo'@'localhost' IDENTIFIED BY 'lacontrase\u00f1a';\r\nERROR 1396 (HY000): Operation CREATE USER failed for 'foo'@'localhost'<\/pre>\n<\/blockquote>\n<p>Entonces proced\u00ed a verificar si exist\u00eda en la tabla mysql.user:<\/p>\n<blockquote>\n<pre>mysql&gt; select user,host from mysql.user where user = 'foo';\r\nEmpty set (0.00 sec)<\/pre>\n<\/blockquote>\n<p>Lo anterior sucede porque el usuario todav\u00eda existe en la tabla mysql.db , lo cual se puede solucionar de la siguiente manera:<\/p>\n<p>1. Utilizando comandos mysql de manejo de usuarios:<\/p>\n<blockquote><p><span class=\"Apple-style-span\" style=\"font-family: monospace; font-size: 12px; line-height: 18px; white-space: pre;\">REVOKE priv1,priv2,priv3,etc&#8230; FROM &#8216;foo&#8217;@&#8217;localhost&#8217;; <\/span><\/p>\n<pre><code>DROP USER 'foo'@'localhost'; <\/code><\/pre>\n<\/blockquote>\n<p>2. Eliminandolo directamente de la tabla mysql.db<\/p>\n<blockquote><p>delete from mysql.db where user=foo<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>MySQL puede ser un poco delicado al momento de manipular usuarios. Al intentar crear un usuario, el cual yo sab\u00eda que existi\u00f3 en alg\u00fan momento, me devolvi\u00f3 el error 1396 mysql&gt; CREATE USER &#8216;foo&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;lacontrase\u00f1a&#8217;; ERROR 1396 (HY000): Operation CREATE USER failed for &#8216;foo&#8217;@&#8217;localhost&#8217; Entonces proced\u00ed a verificar si exist\u00eda en la tabla [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[184,175,185],"class_list":["post-556","post","type-post","status-publish","format-standard","hentry","category-linux","tag-create","tag-mysql","tag-user"],"_links":{"self":[{"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/posts\/556"}],"collection":[{"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/vostorga.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=556"}],"version-history":[{"count":3,"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/posts\/556\/revisions"}],"predecessor-version":[{"id":558,"href":"https:\/\/vostorga.org\/index.php?rest_route=\/wp\/v2\/posts\/556\/revisions\/558"}],"wp:attachment":[{"href":"https:\/\/vostorga.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vostorga.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vostorga.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}