WordPress Database Tutorial: Overview of MySQL Structure & phpMyAdmin

Every website owner should understand the WordPress database (MySQL) structure and how it's used to store the core elements of your WordPress website like the post content, categories, comments, user accounts, and settings.

Watch this WordPress database tutorial to get a high-level overview of how to access & edit the MySQL database tables and option values!

The best way to support or say "thanks" is to start your website idea!

If you use my affiliate links, I get a small cut (no extra cost to you) that helps me create free tutorials like this.

Here are the chapters to follow along:

Intro - 00:00
WP database & phpMyAdmin- 00:23
wp_users table - 01:19
Entries from plugins or themes - 03:44
wp_terms table - 04:25
wp_comments table - 06:23
wp_posts table - 07:06
wp_options table - 10:24
Now take action - 12:30

Use the links below to build your side business today!

___________________________________

Start Freelancing & Make Money with Your Skills!

___________________________________

Create Your First Website or Blog Today!

___________________________________

DISCLAIMER: Please note that some links are affiliate promotions. I only recommend products & services that I know and trust.

[rittickmondal]

Thank you for this tutorial. It will help me to build plugin

[adityaparab]

One question, instead of filling up data in wp_users can we create our own users table and fill data in that with extra fields ? if yes please let me know how or direct me to the appropritae source.

[alanjames]

Hi I already have a database on mysql with my iOS. If I make a new website can I hook it up to my existing database? And make the log in and sign up link to my existing database and users?

[toristreats]

Thanks! Building a website with wp rn and this will be super useful ^-^

[j.d.f]

So how does phpmyadmin integrate with wordpress dashboard? We keep getting an error message: "> Failed to repair the wpxt_comments table. Error: Incorrect file>format 'wpxt_comments'" is this my wordpress dashboard or with the hosting site?

[dejahvoeivoe]

How to make Wordpress Database work with write and read-only ?