AWS Lightsail and Wordpress Admin Login Error

Question

I am trying to log in to my WP-Admin page and I think I tried to log in with the wrong user name too many times.  Now I am getting a message to contact the administrator which is me.  I need to know how to reset this so I can get back to the login page.

Below is a screenshot of the error page. Does anyone know how to reset this page so I can access it?
https://share.getcloudapp.com/WnuZXzrQ

The access to that page has been restricted by the administrator of this website
You don’t have access to this page. Please contact the administrator of this website for further assistance.

Answer

1. You need to SSH into the instance
2. Run the following command to see the list of login users in the database. You must enter the MySQL root password. This password is located in the **/home/bitnami/bitnami_application_password** file:
`mysql -u root -p bitnami_wordpress -e "SELECT * FROM wp_users;"`
3.  Note the ID of the user that you want to reset the password for. Then, run the following command. Be sure to replace NEWPASSWORD with your desired password and ADMIN-ID with the user ID obtained in step 2:
`mysql -u root -p bitnami_wordpress -e "UPDATE wp_users SET user_pass=MD5('NEWPASSWORD') WHERE ID='ADMIN-ID';"`

Answer

Hi,

Thanks for using Lightsail. This guide may help you set up your WordPress instance correctly:

https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-quick-start-guide-wordpress

AWS Lightsail and Wordpress Admin Login Error

Contenido relevante