How to Reset a WordPress Users Password using SQL? You can quickly set a WordPress users password to the new ‘somenewpassword’ text as seen below, assuming that the user login is ‘theirusername’. Change the username and password to whatever you’d like and execute the query. How to Get a List of Subscribers? The below example […]
How to Change WordPress Default Admin Name? You’ve been reading about securing WordPress and figured it was time to change the default administrator name to something other than admin or Admin, in an effort to secure your site. In order to target your admin account and break in, a hacker will need to guess the […]
What’s the #1 Rule About Working with the WordPress Database / Tables? The most important WordPress rule is to backup the database before making changes! What’s the #2 Rule About Working with the WordPress Database / Tables? Make sure you work on the table you’re concerned with as well as the meta tables that contain […]
How to Find WordPress Posts with the Most Spam Comments using SQL? The below query will help you identify the top 7 posts having the most comments that have been flagged as spam. How to Find WordPress Posts with the Most Comments using SQL? The below query will help you identify the top 7 posts […]