Hemos visto varias maneras de recuperarnos del desastre (aparente) de perder la contraseña de usuario, no digamos si es la de administrador, pero aún quedan posibles soluciones, aun cuando perdiéramos el acceso FTP, y es recurrir a una query SQL.

Para ello deberíamos ejecutar el siguiente comando en la interfaz web de phpMyAdmin o desde la línea de comandos:

SQL:

  1. UPDATE wp_users SET user_pass = MD5( ‘nueva-clave’ ) WHERE user_login = ‘nombre-usuario-admin’;

Solo tienes que sustituir ‘nueva-clave‘ por la contraseña nueva que quieres asignar y ‘nombre-usuario-admin‘ por el nombre (username) del usuario administrador, por ejemplo “admin

¿Te gustó este post? ¡Compártelo!

<a rel="nofollow" href="http://bitacoras.com/anotaciones/http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F" title="Bitacoras.com"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/bitacoras.png" alt="Bitacoras.com" /></a>
<a rel="nofollow" href="http://twitter.com/home?status=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F" title="TwitThis"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/twitter.png" alt="TwitThis" /></a>
<a rel="nofollow" href="http://www.facebook.com/share.php?u=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F&amp;t=Como%20cambiar%20la%20clave%20de%20admin%20con%20una%20query%20SQL" title="Facebook"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/facebook.png" alt="Facebook" /></a>
<a rel="nofollow" href="http://meneame.net/submit.php?url=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F" title="Meneame"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/meneame.png" alt="Meneame" /></a>
<a rel="nofollow" href="http://www.google.com/bookmarks/mark?op=edit&amp;bkmk=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F&amp;title=Como%20cambiar%20la%20clave%20de%20admin%20con%20una%20query%20SQL&amp;annotation=%0D%0A%0D%0AHemos%20visto%20varias%20maneras%20de%20recuperarnos%20del%20desastre%20%28aparente%29%20de%20perder%20la%20contrase%C3%B1a%20de%20usuario%2C%20no%20digamos%20si%20es%20la%20de%20administrador%2C%20pero%20a%C3%BAn%20quedan%20posibles%20soluciones%2C%20aun%20cuando%20perdi%C3%A9ramos%20el%20acceso%20FTP%2C%20y%20es%20recurrir%20a%20una%20query%20S" title="Google Bookmarks"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/googlebookmark.png" alt="Google Bookmarks" /></a>
<a rel="nofollow" href="http://delicious.com/post?url=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F&amp;title=Como%20cambiar%20la%20clave%20de%20admin%20con%20una%20query%20SQL&amp;notes=%0D%0A%0D%0AHemos%20visto%20varias%20maneras%20de%20recuperarnos%20del%20desastre%20%28aparente%29%20de%20perder%20la%20contrase%C3%B1a%20de%20usuario%2C%20no%20digamos%20si%20es%20la%20de%20administrador%2C%20pero%20a%C3%BAn%20quedan%20posibles%20soluciones%2C%20aun%20cuando%20perdi%C3%A9ramos%20el%20acceso%20FTP%2C%20y%20es%20recurrir%20a%20una%20query%20S" title="del.icio.us"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/delicious.png" alt="del.icio.us" /></a>
<a rel="nofollow" href="https://favorites.live.com/quickadd.aspx?marklet=1&amp;url=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F&amp;title=Como%20cambiar%20la%20clave%20de%20admin%20con%20una%20query%20SQL" title="Live"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/live.png" alt="Live" /></a>
<a rel="nofollow" href="http://technorati.com/faves?add=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F" title="Technorati"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/technorati.png" alt="Technorati" /></a>
<a rel="nofollow" href="http://ping.fm/ref/?link=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F&amp;title=Como%20cambiar%20la%20clave%20de%20admin%20con%20una%20query%20SQL&amp;body=%0D%0A%0D%0AHemos%20visto%20varias%20maneras%20de%20recuperarnos%20del%20desastre%20%28aparente%29%20de%20perder%20la%20contrase%C3%B1a%20de%20usuario%2C%20no%20digamos%20si%20es%20la%20de%20administrador%2C%20pero%20a%C3%BAn%20quedan%20posibles%20soluciones%2C%20aun%20cuando%20perdi%C3%A9ramos%20el%20acceso%20FTP%2C%20y%20es%20recurrir%20a%20una%20query%20S" title="Ping.fm"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/ping.png" alt="Ping.fm" /></a>
<a rel="nofollow" href="http://www.wikio.com/vote?url=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F" title="Wikio"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/wikio.png" alt="Wikio" /></a>
<a rel="nofollow" href="http://www.printfriendly.com/getpf?url=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F" title="Turn this article into a PDF!"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/pdf.png" alt="Turn this article into a PDF!" /></a>
<a rel="nofollow" href="mailto:?subject=Como+cambiar+la+clave+de+admin+con+una+query+SQL&amp;body=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F" title="E-mail this story to a friend!"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/email_link.png" alt="E-mail this story to a friend!" /></a>
<a rel="nofollow" href="http://www.printfriendly.com/print?url=http%3A%2F%2Fayudawordpress.com%2Fcomo-cambiar-la-clave-de-admin-con-una-query-sql%2F" title="Print this article!"><img src="http://ayudawordpress.com/wp-content/plugins/sociable/images/printfriendly.png" alt="Print this article!" /></a>


Via http://feedproxy.google.com/~r/AyudaWordpress/~3/BvmjORrqgFY/

Related Posts with Thumbnails
Tagged with:  

Comments are closed.

WordPress Blog