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.
🌎 How to Install WordPress in Minutes 👉 websiteprofitcourse.com/hosting/
✅ Start now with HostGator 👉 websiteprofitcourse.com/hostg...
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
View blog post - websiteprofitcourse.com/wordp...
Use the links below to build your side business today!
___________________________________
Start Freelancing & Make Money with Your Skills!
🧰 15 Tools to Start Your Web Design Business - websiteprofitcourse.com/dl15
❓ Web Design Client Questionnaire - websiteprofitcourse.com/dl02
⌚ Time Tracker Sheet - websiteprofitcourse.com/dl05
🤝 Web Design Business Pro Tools & Training - websiteprofitcourse.com/join
___________________________________
Create Your First Website or Blog Today!
💻 WordPress 101 Training - websiteprofitcourse.com/dl03
🚀 Launch Your Blog in 14 Days - websiteprofitcourse.com/14day
🎨 Drag & Drop WordPress Page Builder - websiteprofitcourse.com/divi/
___________________________________
DISCLAIMER: Please note that some links are affiliate promotions. I only recommend products & services that I know and trust.
Пікірлер: 7
Thank you for this tutorial. It will help me to build plugin
explained very clearly
Thanks! Building a website with wp rn and this will be super useful ^-^
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.
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?
@RayDelVecchio
2 жыл бұрын
If the underlying database structure doesn't match WP, I don't think that'll work. You'd probably have to figure out a way to import your database into WP, or write custom code to use them together. Definitely sounds like an advanced issue that you'll have to dig into more details!
How to make Wordpress Database work with write and read-only ?