Remove page/post manually from database

Hi guys,

I ran into a problem with my WordPress installation where a random page was displayed on the front end, but was not visible in the admin portal.
I did a but of research and found that no one really had a solution to this problem… so I took the challenge and figured it out 🙂

If you run into a similar issue and you need to remove a page/post manually follow the following steps:

1) Identify what the rogue post/page’s post ID is
– Once on the page, right click in your browser and select “inspect element”
– Right click <div id="content">...</div>, edit as HTML, in there you should see the article ID (example: <article id="post-96" class="post-96 page type-page status-publish hentry">)

2) Once this is done you may enter your DB editor, I specifically use MySQL Workbench, I like it, looks pretty 🙂
– Go into your database and look up the _posts table (example: wp_posts)
– In ID, find the post ID, as in this example, 96
– Now, delete the correct row and apply

3) Refresh your browser (clear cache – best results), the page/post no longer exists.

I truly hope this helps those who had the same problem as me.