Recientemente, uno de nuestros usuarios nos preguntó cómo restablecer la contraseña de administrador de WordPress en localhost? Si está ejecutando WordPress en local host y olvida su contraseña, entonces no se puede restablecer por correo electrónico. En este artículo, le mostraremos cómo restablecer la contraseña de administrador de WordPress en localhost.
Por qué el restablecimiento de contraseña no funciona en Localhost?
El término localhost se utiliza para describir un servidor local que no está disponible para el público en general. Por ejemplo: su ordenador personal.
Muchos usuarios de WordPress instalan WordPress en localhost (en su ordenador) para probar cambios, diseñar sitios web, probar nuevos plugins e incluso aprender WordPress.
Si aún no lo has probado, consulta nuestro tutorial sobre cómo instalar WordPress en tu ordenador Windows utilizando WAMP.
Los usuarios de Mac pueden seguir las instrucciones de nuestro tutorial sobre cómo instalar WordPress localmente en Mac usando MAMP.
Ahora aquí está el problema que algunos principiantes pueden encontrarse.
Si olvida su contraseña de administrador de WordPress mientras trabaja en localhost, entonces NO podrá restablecerla usando la opción normal de restablecimiento de contraseña en WordPress.
La opción de restablecer contraseña le envía un correo electrónico con un enlace para restablecer su contraseña de WordPress. Para poder enviar correos electrónicos, su servidor necesita activar la función de correo.
Esta función está desactivada por defecto en los servidores locales, lo que significa que WordPress no podrá enviar el correo electrónico de restablecimiento de contraseña.
Pero no se preocupe, hay una manera de restablecer su contraseña de WordPress en localhost.
¿Preparado? Vamos a los primeros pasos.
Tutorial en vídeo
Si no te gusta el vídeo o necesitas más instrucciones, sigue leyendo.
Restablecer la contraseña de administrador de WordPress en Localhost
Vamos a utilizar phpMyAdmin para restablecer la contraseña en localhost. Simplemente visite el panel de control phpMyAdmin escribiendo esta URL en la barra de dirección de su navegador / explorador:
http://localhost/phpmyadmin/
Se le pedirá que proporcione su nombre de usuario y contraseña de MySQL. Normalmente, el nombre de usuario es root sin contraseña.
Una vez conectado, debe seleccionar su base de datos de WordPress.
Una vez que seleccione su base de datos, verá un anuncio / catálogo / fichas en su base de datos de WordPress. Siga adelante y haga clic en el enlace examinar siguiente a la tabla de usuarios de WordPress.
Ahora verá la lista de entradas / registros en su tabla de usuarios. El número de filas dependerá del número de usuarios registrados en su sitio WordPress.
A continuación, debe hacer clic en el enlace Editar situado al lado del nombre de usuario del usuario administrador.
Esto abrirá un formulario donde puede editar la información almacenada en la base de datos de WordPress para ese usuario.
Desplácese hasta el campo user_pass y escriba una nueva contraseña en la columna ‘value’. A continuación, seleccione MD5 en la columna “función”.
No olvides hacer clic en el botón Ir de la parte inferior para guardar los cambios.
Eso es todo, ahora puede acceder / acceso a su sitio de WordPress en localhost utilizando la nueva contraseña.
Si por alguna razón le resulta difícil seguir el método phpMyAdmin, consulte nuestra guía sobre cómo crear un usuario administrador de WordPress utilizando su archivo functions.php. Simplemente abre el archivo functions.php de tu tema y pega el código del artículo anterior, y estarás listo.
Esperamos que este artículo te haya ayudado a aprender cómo restablecer la contraseña de administrador de WordPress en localhost. Puede que también quieras ver nuestra guía práctica sobre cómo mover WordPress de un servidor local a un sitio activo.
Si te ha gustado este artículo, entonces por favor suscríbete a nuestro canal de YouTube para tutoriales en vídeo de WordPress. También puedes encontrarnos en Twitter y Facebook.
Syed Balkhi says
Hey WPBeginner readers,
Did you know you can win exciting prizes by commenting on WPBeginner?
Every month, our top blog commenters will win HUGE rewards, including premium WordPress plugin licenses and cash prizes.
You can get more details about the contest from here.
Start sharing your thoughts below to stand a chance to win!
Hafiz Muhammad Ansar says
Very nice blog for WordPress help. I recommend for beginners to use this platform. Thankful!
WPBeginner Support says
Glad you found our article helpful!
Administrador
Abdullah says
Amazing, it worked
WPBeginner Support says
Glad our guide was helpful!
Administrador
Nidhi Gupta says
it’s really helpful, thankyou so much
WPBeginner Support says
Glad our guide was helpful!
Administrador
Habu says
Omg you save my life !!! THANK YOU VERY MUCHH !!!
Jahir says
I can not log in now same process…any updates?
WPBeginner Support says
The most common issue would be if you did not set the function to MD5 or click go to apply the changes, you would want to ensure you have done that correctly.
Administrador
Kamondo says
Wonderful! problem solved. Very Simple steps but powerful.
WPBeginner Support says
Glad our guide was helpful
Administrador
Joe says
I’m encoutering this problem now after installing the 2nd WordPress on MAMP. This article is very to the point and I’ll try it tomorrow!
WPBeginner Support says
We hope the guide helps
Administrador
Gerron says
Solid solid info right here, thanks a lot, really helped, so simple
WPBeginner Support says
Glad our guide was helpful
Administrador
Odineks says
Thank you so much. I always find solutions to every of my WP problems here.
I kept having problems with the login page on the frontend not recognizing my new password, I didn’t realize there is a function to pass that message to myPHPadmin.
WPBeginner Support says
Glad our guide was helpful
Administrador
naved ahmed says
Thanks a lot. Finally problem solved within a minute.
WPBeginner Support says
Glad our guide was helpful
Administrador
Mohsin says
I just love this
Love the way you write every thing
WPBeginner Support says
Thank you, glad you like our content
Administrador
Jen says
I tried this and while I was in there also attempted to change my username, which I realize was probably my mistake… but now I can’t log in at all. Is there a way to undo what I’ve done?
WPBeginner Support says
You would need to follow the steps in the article and that would bring you back to where you could edit, you should also be able to use your email as an alternative
Administrador
Justina says
Your Blog is always so full of rich articles. Thanks so much. was stuck for a while because I skip the MD5 option. You are a lifesaver.
WPBeginner Support says
Glad our guide could be helpful
Administrador
Sarah says
Thank you SO MUCH for this! You saved me so many more hours of tinkering with trying to figure out how to log in!!
WPBeginner Support says
Glad we were able to help
Administrador
David says
Thank you ever so much! Normally, I keep this stuff handy; but in this case, I did could not find where I wrote the information down.
You saved a total re-work of a site I was planning.
WPBeginner Support says
Glad our guide could be helpful
Administrador
adeel kamran says
You saved me, I had a lot of work there.
WPBeginner Support says
Glad our guide could help
Administrador
lokesh n says
thank you it’s really working thank you
WPBeginner Support says
You’re welcome glad our article was helpful
Administrador
Vivek says
Hi,
When I reset My password through link then what fileds affected in Database and in which table.
Kindly share this information i am waiting for your response.
WPBeginner Support says
For understanding the database you would want to take a look at our article here: https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/
Administrador
Adnan Khan says
After half an hour of search i just found my help from this site, which solves my problem in no time,
thanks a lot
keep it up guys
WPBeginner Support says
You’re welcome, glad our guides can be helpful
Administrador
Tenasu Mensah says
thanks a lot, kudos to you guys keep the good work doing,you guys are doing great job
WPBeginner Support says
Glad our guide could help
Administrador
Anuj says
It work fine, Thanku so much,
Pádraig says
Really simple and great explanation.
Many thanks for sharing.
Saranya says
Works Good! Thanks a lot.
Patr says
Hello,
I type a new password , click continue and it does not keep the password, it shows a long string of numbers and letters. If I use this , still cannot log in. It looks simple on the video but does not work for me. Thank you.
I looked everywhere on the internet, no solution worling.
Jason says
Same problem here. Did you find a solution? Is there any chance of being hacked?
Christian Gochez says
when I click on the Go button this error appears:
#1881 – Operation not allowed when innodb_forced_recovery > 0
Edward says
Simple and neat! worked thanks
Handel says
I started to just reinstall wordpress, but then decided to do a google search, and there was GOOD OLD RELIABLE WpBeginner.com
Thanks a million!!
Sheriff says
very effective… kudos
Icholia says
Hello
THANKS, Wow there is no other place that you can get well explained information like this , i have been suffering but now i just followed your tutorial and it is a game changer i love you guys and i will always learn from you guys once again thanks
CJ says
Thank you! For those who can’t make it work, remember to use the “MD5” function when changing the password. I almost skipped that part and was stuck for a few minutes.
mohamad hossein says
so use full thank you so much
Janet says
I got completely lost on the video so I tried plugging in the URL. Doesn’t work. Still lost.
Ma says
Thanks so much, you saved me from what could have been a very embarrassing situation!
James says
I change the password, username, userlogin and nickname not I cant login. Any advice?
suganya says
i can’t able to login .because it’s shows me like email is not registered .so what can i do???
Jac says
Thanks so much for providing this info – I was really stuck!
Gerhard SCHNEIBEL says
Thanks a lot for your help. I am very happy with “wpbeginners”.
Renu says
it worked.. thanks a ton..
Anthony says
Hi…
I am so thankful for such great information you provide. I have bookmarked your site a while back.
I have been working on a site in wordpress using xampp on the Apache local server. Just recently, I am not able to login on the admin page. I have managed to create a user name and password that works on about 95% of all sites requiring me to register. I also created a file that lists all my login info for everywhere I need to login, including the WP admin login page, IF I ever forget that info.
I have read this page (https://www.wpbeginner.com/wp-tutorials/how-to-reset-wordpress-admin-password-on-localhost/) and watched the video, also. The only problem is that when I click on the wp_users in phpMyadmin, I get this error- ‘#1932 – Table ‘bitnami_wordpress.wp_users’ doesn’t exist in engine.’
Am I reduced to re-installing WordPress, or is there another way around it?
I have tried restoring my computer (using system restore) to various past restore points, but with no luck. Can you help me with this?
I would be so thankful!!! I have put months of work into designing a site to launch, and I HAVE exported everything to a file quite a few times using WordPress import plugin (something like that).
Could you provide a solution?
Thank you so much…
Anthony
WPBeginner Support says
Hi Anthony,
you can also add an admin user by adding code to your current WordPress theme’s admin file.
Administrador
Kakaire Charles says
Extremely wonderful. Thank you for sharing.
Gaurav says
i tried this but not working
shaikh muneer says
super way to reset admin password thank you for share this