{"id":17,"date":"2006-08-12T16:10:25","date_gmt":"2006-08-12T16:10:25","guid":{"rendered":"http:\/\/stefano.zero.org\/blog\/2006\/08\/12\/recuperar-password-de-mysql\/"},"modified":"2006-08-12T16:35:10","modified_gmt":"2006-08-12T16:35:10","slug":"recuperar-password-de-mysql","status":"publish","type":"post","link":"https:\/\/stefano.salvatori.cl\/blog\/2006\/08\/12\/recuperar-password-de-mysql\/","title":{"rendered":"Recuperar password de mysql"},"content":{"rendered":"

Un buen how-to que espero a alguien le sirva alguna vez<\/p>\n

Ojo el passworde root no se recupera, solo se cambia, este howto esta hecho en debian pero solo debes cambiar los path de los binarios y listo<\/p>\n

Primero debes detener el servidor mysql<\/p>\n

root@arda:~$ \/etc\/init.d\/mysql stop<\/strong><\/p>\n

Luego debes reiniciarlo sin los permisos de las tablas<\/p>\n

root@arda:~$ <\/strong> \/usr\/bin\/mysqld_safe –skip-grant-tables &<\/strong><\/p>\n

Luego correr mysql<\/p>\n

stefano@arda:~$ mysql <\/strong><\/p>\n

Luego usar la tabla mysql<\/p>\n

mysql> use mysql; <\/strong><\/p>\n

Hacer el cambio via sql, recuerden cambiar el password y el host
\nmysql> update user set password = password(‘nuevo_password’) where user=’root’ and host=’localhost’;<\/strong><\/p>\n

Luego<\/p>\n

mysql> flush privileges;<\/strong><\/p>\n

mysql> exit<\/strong><\/p>\n

Paramos el mysql y lo volvemos a reiniciar<\/p>\n

root@arda:~$ \/etc\/init.d\/mysql stop<\/strong><\/p>\n

root@arda:~$ \/etc\/init.d\/mysql start <\/strong><\/p>\n

Y luego ingresan a la mysql asi :D<\/p>\n

root@arda:~$ mysql -u root -p<\/strong><\/p>\n

Y listo ahora ya cambiaron el password de root de su servidor mysql ( claro que necesitan ser root de la maquina para detener mysql )<\/p>\n

Ojala les sirva, sobre todo cuando entran a un pc que hacer mucho tiempo no usaban como yo :P<\/p>\n","protected":false},"excerpt":{"rendered":"

Un buen how-to que espero a alguien le sirva alguna vez Ojo el passworde root no se recupera, solo se cambia, este howto esta hecho en debian pero solo debes cambiar los path de los binarios y listo Primero debes detener el servidor mysql root@arda:~$ \/etc\/init.d\/mysql stop Luego debes reiniciarlo sin los permisos de las […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[13,12,11,8],"tags":[],"class_list":["post-17","post","type-post","status-publish","format-standard","hentry","category-how-to","category-linux","category-mysql","category-software"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p5Pxa3-h","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":0,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/posts\/17\/revisions"}],"wp:attachment":[{"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/media?parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/categories?post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/tags?post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}