{"id":1039,"date":"2012-04-30T22:36:23","date_gmt":"2012-04-30T21:36:23","guid":{"rendered":"http:\/\/www.xarcom.net\/blog\/?p=1039"},"modified":"2012-04-30T22:36:23","modified_gmt":"2012-04-30T21:36:23","slug":"como-resetear-el-password-de-root-en-mysql","status":"publish","type":"post","link":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/","title":{"rendered":"Como Resetear el password de root en MySQL"},"content":{"rendered":"<p>Momento angustioso, no porque no funciona el servicio, si no porque te dices a ti mismo: \u00abCon lo poco que cuesta documentar las cosas!!!!!\u00bb<\/p>\n<p>Para resetear el password de root en MySQL, primero pararemos mysql para posteriormente arrancarlo sin autenticaci\u00f3n<\/p>\n<pre>service mysql stop<\/pre>\n<p>Esperaremos hasta que se haya detenido y ejecutaremos:<\/p>\n<pre>mysqld_safe \u2013skip-grant-tables &<\/pre>\n<p>Una vez hecho esto podremos acceder como root sin utilizar contrase\u00f1a con el siguiente comando:<\/p>\n<pre>mysql -uroot mysql<\/pre>\n<p>En la linea de comandos de MySQL escribiremos el siguiente comando para cambiar el password (donde abcd es el password):<\/p>\n<pre>UPDATE user SET password=PASSWORD(\u201cabcd\u201d) WHERE user=\u201droot\u201d;<\/pre>\n<pre>FLUSH PRIVILEGES;<\/pre>\n<p>Ahora el password de MySQL es abcd. Podemos probar de iniciar sesi\u00f3n con la nueva contrase\u00f1a:<\/p>\n<pre>mysql -uroot -pabcd mysql<\/pre>\n<p>Si el \u00faltimo paso ha funcionado, procederemos a dejar MySQL operativo. Para ello ejecutaremos los siguientes comandos:<\/p>\n<pre>\/etc\/init.d\/mysql stop<\/pre>\n<pre>\/etc\/init.d\/mysql start<\/pre>\n<p><a title=\"Como Resetear el password de root en MySQL\" href=\"http:\/\/www.xarcom.net\">Como Resetear el password de root en MySQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Momento angustioso, no porque no funciona el servicio, si no porque te dices a ti mismo: \u00abCon lo poco que cuesta documentar las cosas!!!!!\u00bb Para resetear el password de root en MySQL, primero pararemos mysql para posteriormente arrancarlo sin autenticaci\u00f3n service mysql stop Esperaremos hasta que se haya detenido y ejecutaremos: mysqld_safe \u2013skip-grant-tables &#038; Una [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[208],"tags":[277,209,210],"class_list":["post-1039","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-password","tag-reset"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como Resetear el password de root en MySQL - XARCOM BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como Resetear el password de root en MySQL - XARCOM BLOG\" \/>\n<meta property=\"og:description\" content=\"Momento angustioso, no porque no funciona el servicio, si no porque te dices a ti mismo: \u00abCon lo poco que cuesta documentar las cosas!!!!!\u00bb Para resetear el password de root en MySQL, primero pararemos mysql para posteriormente arrancarlo sin autenticaci\u00f3n service mysql stop Esperaremos hasta que se haya detenido y ejecutaremos: mysqld_safe \u2013skip-grant-tables &amp; Una [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"XARCOM BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-30T21:36:23+00:00\" \/>\n<meta name=\"author\" content=\"XarCom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"XarCom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/\"},\"author\":{\"name\":\"XarCom\",\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/person\/7d4f423ee0738574821bd898993d2136\"},\"headline\":\"Como Resetear el password de root en MySQL\",\"datePublished\":\"2012-04-30T21:36:23+00:00\",\"dateModified\":\"2012-04-30T21:36:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/\"},\"wordCount\":136,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/blog.xarcom.net\/#organization\"},\"keywords\":[\"MySQL\",\"password\",\"reset\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/\",\"url\":\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/\",\"name\":\"Como Resetear el password de root en MySQL - XARCOM BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.xarcom.net\/#website\"},\"datePublished\":\"2012-04-30T21:36:23+00:00\",\"dateModified\":\"2012-04-30T21:36:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/blog.xarcom.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como Resetear el password de root en MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.xarcom.net\/#website\",\"url\":\"https:\/\/blog.xarcom.net\/\",\"name\":\"XARCOM BLOG\",\"description\":\"Aquello que quer\u00edas saber y nadie te explic\u00f3\",\"publisher\":{\"@id\":\"https:\/\/blog.xarcom.net\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.xarcom.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.xarcom.net\/#organization\",\"name\":\"XARCOM BLOG\",\"url\":\"https:\/\/blog.xarcom.net\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2024\/06\/Logo_Xarcom.png\",\"contentUrl\":\"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2024\/06\/Logo_Xarcom.png\",\"width\":200,\"height\":65,\"caption\":\"XARCOM BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/person\/7d4f423ee0738574821bd898993d2136\",\"name\":\"XarCom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ed4b68cfa45d0ca9932a034f55490417801792278ea2a011a14097d2a82a7150?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ed4b68cfa45d0ca9932a034f55490417801792278ea2a011a14097d2a82a7150?s=96&d=mm&r=g\",\"caption\":\"XarCom\"},\"url\":\"https:\/\/blog.xarcom.net\/index.php\/author\/xarcombl0g\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como Resetear el password de root en MySQL - XARCOM BLOG","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/","og_locale":"es_ES","og_type":"article","og_title":"Como Resetear el password de root en MySQL - XARCOM BLOG","og_description":"Momento angustioso, no porque no funciona el servicio, si no porque te dices a ti mismo: \u00abCon lo poco que cuesta documentar las cosas!!!!!\u00bb Para resetear el password de root en MySQL, primero pararemos mysql para posteriormente arrancarlo sin autenticaci\u00f3n service mysql stop Esperaremos hasta que se haya detenido y ejecutaremos: mysqld_safe \u2013skip-grant-tables & Una [&hellip;]","og_url":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/","og_site_name":"XARCOM BLOG","article_published_time":"2012-04-30T21:36:23+00:00","author":"XarCom","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"XarCom","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/#article","isPartOf":{"@id":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/"},"author":{"name":"XarCom","@id":"https:\/\/blog.xarcom.net\/#\/schema\/person\/7d4f423ee0738574821bd898993d2136"},"headline":"Como Resetear el password de root en MySQL","datePublished":"2012-04-30T21:36:23+00:00","dateModified":"2012-04-30T21:36:23+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/"},"wordCount":136,"commentCount":1,"publisher":{"@id":"https:\/\/blog.xarcom.net\/#organization"},"keywords":["MySQL","password","reset"],"articleSection":["MySQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/","url":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/","name":"Como Resetear el password de root en MySQL - XARCOM BLOG","isPartOf":{"@id":"https:\/\/blog.xarcom.net\/#website"},"datePublished":"2012-04-30T21:36:23+00:00","dateModified":"2012-04-30T21:36:23+00:00","breadcrumb":{"@id":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.xarcom.net\/index.php\/como-resetear-el-password-de-root-en-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/blog.xarcom.net\/"},{"@type":"ListItem","position":2,"name":"Como Resetear el password de root en MySQL"}]},{"@type":"WebSite","@id":"https:\/\/blog.xarcom.net\/#website","url":"https:\/\/blog.xarcom.net\/","name":"XARCOM BLOG","description":"Aquello que quer\u00edas saber y nadie te explic\u00f3","publisher":{"@id":"https:\/\/blog.xarcom.net\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.xarcom.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/blog.xarcom.net\/#organization","name":"XARCOM BLOG","url":"https:\/\/blog.xarcom.net\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/blog.xarcom.net\/#\/schema\/logo\/image\/","url":"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2024\/06\/Logo_Xarcom.png","contentUrl":"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2024\/06\/Logo_Xarcom.png","width":200,"height":65,"caption":"XARCOM BLOG"},"image":{"@id":"https:\/\/blog.xarcom.net\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/blog.xarcom.net\/#\/schema\/person\/7d4f423ee0738574821bd898993d2136","name":"XarCom","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/blog.xarcom.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ed4b68cfa45d0ca9932a034f55490417801792278ea2a011a14097d2a82a7150?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ed4b68cfa45d0ca9932a034f55490417801792278ea2a011a14097d2a82a7150?s=96&d=mm&r=g","caption":"XarCom"},"url":"https:\/\/blog.xarcom.net\/index.php\/author\/xarcombl0g\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/posts\/1039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/comments?post=1039"}],"version-history":[{"count":1,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/posts\/1039\/revisions"}],"predecessor-version":[{"id":1040,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/posts\/1039\/revisions\/1040"}],"wp:attachment":[{"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/media?parent=1039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/categories?post=1039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/tags?post=1039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}