I can't login to my lightsail wordpress dashboard

Question

I have been having troubles logging into my wordpress lightsail dashboard. I haven't changed any password for any account but since 2 days ago the login screen tells me that my user and pw are not correct. pw reset isn't working either it cannot send an email. I need help please.

Accepted Answer

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.

Answer

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”;
```

I can't login to my lightsail wordpress dashboard

Relevant content