KNOWNHOST KNOWLEDGE BASE

Hosting Question? Find the Solution - Browse our Guides, Articles, and How-To's

What is an Author in WordPress?

Category: WordPress
Tags: # # #

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 Manage WordPress Users

Category: WordPress
Tags: # # # # #

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 using SQL

Category: WordPress
Tags: # # #

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 […]

WordPress capabilities on single site installs

Category: WordPress
Tags: # # #

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 manage WordPress Admin account

Category: WordPress
Tags: # # # # #

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 […]

WordPress Frequently Asked Questions

Category: WordPress
Tags: # # # # #

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 Debug WordPress

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 […]