MainWP Blog - Sebastian Moran

Two-factor authentication (2FA) is an important security feature that adds an extra layer of protection to your WooCommerce store. With 2FA enabled, a user must provide two forms of identification to log in: their password and a unique verification code generated by an authentication app, sent via SMS, or provided by a hardware token. Securing the login for WooCommerce has become easy with the availability of multiple free plugins on the WordPress.org repository. Wordfence If you are using either the Continue reading the post...

ManageWP is a Software as a Service (SaaS) platform for managing multiple sites, whereas MainWP is an open-source, self-hosted solution that prioritizes privacy for you and your clients when handling multiple websites from a centralized dashboard. Learn: Why Privacy for Your Clients is Important! Before moving forward, let’s learn a bit about the MainWP system. MainWP is a set of two plugins, “MainWP Dashboard” & “MainWP Child”. The MainWP Dashboard plugin is installed on a WordPress website from where you Continue reading the post...

Backup files such as MySQL dumps, and wp-config.php backup files should not be stored in your WordPress install’s public_html (root folder). It’s important to note that the backup wp-config.php file can provide an easy way for a site attacker to find the database credentials. These credentials can then be used to directly connect to your site to insert content in the site’s database or to create an admin user to install and deploy malicious content to your site from plugin Continue reading the post...

Dealing with mixed content issues on WordPress sites can be a pain. The ideal way to solve mixed content issues is to solve those at the database level, so it does not need another plugin dependency to fix mixed content on the site’s front end. If you want a plugin-only solution, then the Better Search Replace plugin will help run a search and replace any HTTP references in the site’s database and change those to HTTPS. Depending on the number Continue reading the post...

It is beneficial if you temporarily enable debugging on your WordPress site to run down any issues happening with the site from active themes, WordPress core version, or active plugins. The default location to store the debug.log file is /wp-content/debug.log, but if you want to change the path where the debug.log file should be stored, add the following snippet into the wp-config.php file replacing the /tmp/ with your folder preference. define( 'WP_DEBUG_LOG', '/tmp/wp-errors.log' ); If you are uncomfortable editing the Continue reading the post...

The All in One SEO is a commonly used SEO plugin with 3+ million active installs. If you want to migrate to a different SEO plugin, you should migrate the existing SEO and delete the previous plugin’s stored data. If you are migrating to the Rank Math SEO plugin, it supports the All in One SEO plugin data migration. The All in One SEO plugin uses the following database tables for data storage; wp_aioseo_cache wp_aioseo_notifications wp_aioseo_posts All in One SEO Continue reading the post...

One of the most widely used form plugins is WPForms. The lite version of WPForms crossed over 5 million active installs. The WPForms plugin uses the following custom database tables for data storage; wp_wpforms_entries wp_wpforms_entry_meta wp_wpforms_entry_fields wp_wpforms_tasks_meta wp_wpforms_admin_builder_templates_cache_update wp_wpforms_email_summaries_fetch_info_blocks wp_wpforms_process_forms_locator_save wp_wpforms_process_forms_locator_scan wp_wpforms_admin_addons_cache_update The database prefix will differ depending on the table prefix defined in your site’s wp-config.php file. The WPForms plugin has an uninstall option which can be found in the settings menu in wp-admin; WPForms > Settings > Misc Continue reading the post...

If you want to migrate from the Yoast SEO plugin to alternative plugins, it is also worth making sure that any Yoast SEO plugin data is deleted from the site’s database. The custom database tables that the Yoast SEO plugin creates; wp_yoast_indexable wp_yoast_indexable_hierarchy wp_yoast_migrations wp_yoast_primary_term wp_yoast_prominent_words(note: only available in the Yoast SEO Premium plugin) wp_yoast_seo_links The option names that the Yoast SEO plugin uses; _transient_wpseo_unindexed_post_link_count _transient_timeout_wpseo_unindexed_post_link_count _transient_wpseo_unindexed_term_link_count _transient_timeout_wpseo_unindexed_term_link_count _transient_wpseo_total_unindexed_general_items _transient_timeout_wpseo_total_unindexed_general_items _transient_wpseo_total_unindexed_post_type_archives _transient_timeout_wpseo_total_unindexed_post_type_archives _transient_yoast_i18n_wordpress-seo_promo_hide wpseo_social wpseo_titles wpseo yoast_migrations_free Wpseo_taxonomy_meta If you Continue reading the post...

There are some self-hosted analytics solutions for your WordPress website, and one of the most recent plugins is Burst Statistics. It is a privacy-friendly solution as it is designed to store data on your WordPress website, which is not shared with any third party. Its user-friendly features allow for quick setup and convenient viewing of your website visitors. You can consider it as a partial alternative to Google Analytics. After the successful installation and activation of the Burst Statistics plugin, Continue reading the post...

The WP Statistics is a widely used plugin with over 600k active installations and is used as a self-hosted solution to track analytics. The WP Statistics plugin uses the following custom database tables for data storage; wp_statistics_exclusions wp_statistics_historical wp_statistics_pages wp_statistics_search wp_statistics_useronline wp_statistics_visit wp_statistics_visitor wp_statistics_visitor_relationships The plugin does not have a built-in way to clean or delete the custom database tables other than manually deleting the custom tables using an application such as phpMyAdmin, or a plugin such as WP-Optimize. If Continue reading the post...