- Le plus récent
- Le plus de votes
- La plupart des commentaires
Restored an older snapshot of the instance and it worked. I was able to login to wp dashboard with the same credentials I've used from the start.
Can I login to the WordPress database (MySQL)?
If you can, you can change the password directly from the database or create a new user.
Basically, it is not recommended to manipulate the database directly and should only be done in case of emergency.
Always make a backup before executing SQL statements.
Users can be created with the following SQL statement.
Change the information after "VALUES" to yours.
INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`) VALUES ('your username', MD5('your password'), 'your firstname & your lastname', 'your email', '0');
Also, if you get an error with the above SQL statement, such as "user_registered" is not enough, please change to the following SQL statement.
INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`, 'user_registered') VALUES ('your username', MD5('your password'), 'your firstname & your lastname', 'your email', '0','2023-05-01 00:00:00');
If you want to change only the password, you can use the following SQL statement.
UPDATE `wp_users` SET `user_pass` = MD5( ‘your new_password’ ) WHERE `wp_users`.`user_login` = “your username”;
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a un an
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 9 mois
Hey thanks. I resolved my issue. I restored an older snapshot of the instance and the same login credentials worked. I tried your suggestion but it popped some error out. Thanks though I appreciate your help.