Unlock Your WordPress Website

Requirements

Access to AWS LightSail

Time Duration 30 minutes

1. SSH in Bitnami EC2

You can use the web terminal on the AWS LightSail console or use your favorite SSH tool.

2. Find your Bitnami Credentials

cat bitnami_credentials

if the username doesn’t work refer to this link //docs.bitnami.com/general/apps/drupal/get-started/find-credentials-link-mysql/

3. Verify MySQL Version stack

test -d /opt/bitnami/mariadb && echo "MariaDB" || echo "MySQL"

MariaDB was my database.

4. Login to MySQL

using the below command, enter your password when prompted:

mysql -u your_username -p;

5. List the databases

SHOW DATABASES;

6. Dive in your WordPress Database

USE database_wordpress;

7. Validate wp_wfblocks7 can be seen

SHOW TABLES;

8. Truncate wp_wfblocks7

TRUNCATE TABLE wp_wfblocks7;

Congratulations you have unlocked your website.

References:
//docs.bitnami.com/
//docs.bitnami.com/general/apps/drupal/get-started/understand-default-config-mariadb/
//mariadb.com/kb/en/show-tables/
//mariadb.com/kb/en/truncate-table/