Our WordPress password recovery series is sorted by popularity of the mentioned tutorial. For starters, you have the most popular recovery option, in other words, use phpMyAdmin.
Hay ciertos proveedores de alojamiento Web que no proporcionan cPanel y / o phpMyAdmin. ¿Que haces entonces? ¡Lee este artículo!
Rest assured, since WordPress used a database (commonly MySQL), every hosting provider must have a database management system better known as DBMS. In this tutorial, we will use the MySQL command prompt (abbreviated as CMD) which is a free DBMS licensed under the GNU General Public License v2.
Prerequisites
Recovering your password using MySQL CMD involves fewer steps and can be considered a universal password recovery system; in the sense that it can be used in almost any plausible scenario.
Regardless, you must have a working knowledge of databases and how WordPress interacts with one. Apart from that, at the same time you need to know the following technical aspects:
- Name of the database used by the WordPress installation
- Dirección del server MySQL (IP o nombre de host)
- Credenciales de inicio de sesión de MySQL del Username ‘root’
- The user ID of the user whose associated password you want to change. Usually it is 1 since, during the WordPress installation, we create the administrator user. Note that the username of the admin user can be 'Jack' or 'Mike' or 'admin', but the user ID will always be 1, since this is the first user you are creating.
Log in to the MySQL command prompt
Windows
If you are running an offline installation of WordPress on Windows using WAMP or XAMPP, to start MySQL CMD, click the WAMP icon> MySQL> MySQL console. This connects you directly. No need to access any more commands. Go to the next step.
Linux
Most of the providers of shared hosting, VPS, dedicated servers use a variant of Linux that includes CentOS, Debian, Fedora or Ubuntu, to name a few.
If you are running an offline installation of WordPress on Linux using LAMP, just launch the terminal emulator and type the command:
mysql -u root -p
Si está intentando restablecer la contraseña en un servidor remoto, conéctese por medio de de SSH utilizando cualquier client SSH, a modo de ejemplo, el cliente favorito del mundo, Putty. Una vez que haya iniciado sesión en el servidor remoto, para iniciar sesión en MySQL, use el siguiente comando:
mysql -u root -p
WordPress password reset:
Now that you have access to the MySQL CMD indicated by the "mysql>" prompt, it's time to do the magic. Well, no magic, just good MySQL commands. 😀
ASSUMPTIONS:
- WordPress database name: wp_genesis
- User ID: 1
- New password: WPEXPLORER
WORKING THE MAGIC:
Enter the following ditto commands:
use wp_genesis; SELECT ID, user_login, user_pass FROM wp_users; UPDATE wp_users SET user_pass = MD5 ('WPEXPLORER') WHERE ID = 1 LIMIT 1;
In case the last command does not go according to the screenshot, remove the single quotes and write them manually in the CMD. That should do the trick.
This will reset the administrator user password to WPEXPLORER. Of course, when setting a new password, you will have to use a stronger one. Once this is done, you can exit MySQL CMD using the command:
exit
Video-tutorial
Here is a video tutorial that describes the whole process. I would recommend reading the article first, but if you are looking for a quick fix, this is your tail:
conclusion
Como conclusión de nuestra serie de recuperación de contraseña de WordPress, me gustaría recordarle que la parte (a) es más simple debido a que el 90% de las compañías de alojamiento vienen con phpMyAdmin. Pero si tiene algo de tiempo libre, le recomiendo probar esta parte (usando MySQL) puesto que le dará algo de experiencia en el manejo de comandos y bases de datos MySQL. Y quién sabe, ¡quizá be de alguna utilidad en el futuro!
Prevention is better than cure
I started this series by saying how password storage / backup services like Last pass prosperar. No me malinterpretes, no era mi intención parecer degradante. De hecho, amo y uso LastPass todos los días. Lo tengo instalado en mi teléfono y en todos los browsers de todas mis computadoras. La vida (para mí) se detendría sin él. Honestamente, no puedo sobrevivir sin él.
LastPass, puesto que es uno de los software de administración de contraseñas más completos y fáciles de usar que existen. Recomiendo encarecidamente usarlo. Y cada vez que inicie sesión en un nuevo sitio web, ¡asegúrese de guardar la contraseña! 😉
