one draft 2

OneNote Draft

1. SSH in your Bitnami Lightsail EC2.

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

2. Get 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. Find out which DB Stack runs

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

MariaDB was mine

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. Enter your WordPress Database

USE database_wordpress;

7. Verify 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/

//support.serversaurus.com.au/hc/en-us/articles/4402769730319-Remove-Wordfence-firewall-block-via-MySQL-CLI

//mariadb.com/kb/en/show-tables/