With 1,000 or so ecommerce plugins to choose from on WordPress.org alone, any discussion of adding an online store to WordPress will be limited in scope. We’ll look at the most popular option and go through the steps for adding an online store (an ecommerce plugin) to your WordPress site. The most obvious choice is […]
An author is a role in WordPress whereby someone can create and publish content, upload files, as well as delete content they’ve written. Rather than risking upsetting or firing an author, which could result in them deleting all the content they’ve produced, instead consider using the contributor role for content creators and writers. What’s the […]
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 Clean Up and Optimize WordPress Posts by Removing Specific Post Meta Data? If you’re uninstalled a plugin or have stopped using a custom field, it could be that you’d like to remove all instances of post metadata relating to a particular meta key. If so: How to Clean Up Orphaned User Meta in […]
What are the Possible Roles for wp_capabilities in the Database? There are only a handful of roles that can be found as meta_values in the wp_usermeta table, each corresponding to the meta_key of wp_capabilities. Possible roles include: administrator editor author contributor subscriber What are the WordPress Capabilities of Admins? activate_plugins add_users create Reusable Blocks create_users […]
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 […]
DEBUGGING – TROUBLESHOOTING Debug mode gives some troubleshooting information that you don’t want to see all the time, unless you’re troubleshooting an issue. When that’s the case, change false to true, clear cache, refresh the page that’s a problem and observe the information. After you fix the problem, remember to change it back again. Debug […]
Option 1: Login to phpMyAdmin, highlight your database and browse the tables. Check the “Type” column to see what type of tables they are… Option 2: Use phpMyAdmin SQL tab and run the query to find the tables that might still be MyISAM: Why Change WordPress Database from MyISAM to InnoDB? Depending on when you […]
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 […]