Tour of the WordPress Database with phpMyAdmin & Adminer WP Database Plugins – SQL & MySQL

In this video, I give you a Tour of the WordPress Database using phpMyAdmin and the Adminer WP Database Plugin which will both help you work with the MySQL Database that WordPress uses.

Support the Channel Through Patreon:
https://www.patreon.com/pixemweb

Check out my Premium WordPress Theme Evo Pro:
https://www.pixemweb.com/premium-wordpress-themes/

Get the Code for this video:
https://www.pixemweb.com/?p=2113

I show you how to run SQL Queries on your database, How to Backup your WordPress Database, How to easily remove Shortcodes from your website and I also describe what each of the 12 default WordPress Database Tables are and what they do.

I also show you how to improve the performance of your WordPress Website by deleting old tables left over from WordPress Plugins you’ve deleted. Even though you may have deleted a WordPress Plugin, often there are still MySQL Database Tables left over that take up space and can cause performance issues on your website.

I also show you how to change content on your website via the database and even how to insert a new Admin User directly from the database without having to log into your website. This is one of the main reasons I recommend that you secure your web hosting account, web server, database and all other credentials for your online accounts because if a hacker gets access to your database, it doesn’t matter what WordPress Security Plugins you’re using.

Think of it like a bank that has the world’s strongest Front Door and Safe Vault Door but the foundation can be easily penetrated or tunneled into.

By the end of the video, you will have a greater understanding of how the WordPress Database works and you will be introduced to two different ways of interacting with the database using either phpMyAdmin or the Adminer WP Database Plugin.

The 12 Default WordPress Database Tables are:
wp_users
wp_usermeta
wp_posts
wp_postmeta
wp_options
wp_terms
wp_termmeta
wp_term_relationships
wp_term_taxonomy
wp_links
wp_comments
wp_commentmeta

Support the channel by:

Domain Name & Hosting
http://shop.pixemweb.com

Premium WordPress Theme
https://www.pixemweb.com/evo-pro-wordpress-theme/

$99 off Realtors IDX Setup Fee
https://signup.idxbroker.com/d/PixemWeb

Don’t forget to Subscribe and follow us @

https://www.patreon.com/pixemweb
http://www.youtube.com/c/Pixemweb?sub_confirmation=1
https://www.pixemweb.com/
https://plus.google.com/+Pixemweb/

https://www.facebook.com/pixemweb
https://www.linkedin.com/in/pixemweb
https://instagram.com/pixemweb/
https://www.quora.com/profile/Joel-Rivera-2

You May Also Like