{"id":13828,"date":"2019-01-13T19:51:37","date_gmt":"2019-01-13T19:51:37","guid":{"rendered":"https:\/\/www.hostinger.com\/tutorials\/?p=13828"},"modified":"2025-02-19T11:06:50","modified_gmt":"2025-02-19T11:06:50","slug":"wordpress-database","status":"publish","type":"post","link":"\/my\/tutorials\/wordpress-database","title":{"rendered":"WordPress Database: What It Is, How to Manage It, and Best Practices"},"content":{"rendered":"

A WordPress database stores all the data that makes up a WordPress website, including login credentials, pages, posts, themes, and plugins.<\/p>

Basic knowledge of databases helps you understand how the platform works and troubleshoot errors more efficiently. It also enables you to perform tasks inaccessible through the WordPress dashboard, such as changing usernames.<\/p>

In this article, we’ll explain what a WordPress database is and why it’s important. We’ll also show how you can access and manage it.<\/p>

\n\n\n\n\n\n\n\n

\n

What Is a WordPress Database?<\/h2>\n

A WordPress database is a storage of your website data that uses the MySQL<\/a> database management system. All WordPress databases have a default MySQL structure, which enables your website to function properly.<\/p>\n <\/div>\n\n\n\n<\/p>

How a WordPress Database Works<\/h2>

When installing WordPress<\/a> for the first time, you’ll also create a database to contain the core tables. It is usually stored on your web host server, often referred to as a database host.<\/p>

A database management system (DBMS)<\/a> is then used to control and manage it. This software splits complex data into smaller parts to organize them better.<\/p>

DBMS works similarly to saving files and folders on a computer drive. Each folder contains specific file categories. This enables users to locate, modify, and delete any desired data easily.<\/p>

\"An<\/a><\/figure>

WordPress uses MySQL as its management system. MySQL uses the Structured Query Language<\/strong><\/a> to create, read, update, and delete data from a database.<\/p>

While most MySQL queries run automatically, users can also perform them manually to change WordPress URLs<\/a> and carry out other tasks.<\/p>

What Is a WordPress Database Host?<\/h3>

A host is a server that stores a database. Usually, a website and its database are hosted on the same server. As a result, localhost<\/a> is the typical hostname used to manage and connect a WordPress site to the database.<\/p>

WordPress users can also use MySQL remote connection<\/a> to connect their database to a remote server. In Hostinger, simply access Remote MySQL<\/strong> in hPanel<\/strong>. Note that a Hostinger hostname is required to enable the remote connection.<\/p>

\"Remote<\/a><\/figure>

What Is a WordPress Database Table?<\/h3>

A database stores data in the form of tables. Each table consists of unique data displayed in columns and rows that contain more specific pieces of information or parameters.<\/p>

By default, a WordPress database contains the following tables;<\/p>

    \n
  1. wp_commentmeta<\/strong> – keeps the metadata of each comment posted on the website.<\/li>\n\n\n\n
  2. wp_comments<\/strong> – stores data related to user comments, including the author name, URL, IP address, email, and comment content.<\/li>\n\n\n\n
  3. wp_links<\/strong> – it was used for holding information from the Links feature. Since the feature has been deprecated, this table is often empty.<\/li>\n\n\n\n
  4. wp_options<\/strong> – contains WordPress configuration settings, such as website URL, default category, and posts per page.<\/li>\n\n\n\n
  5. wp_postmeta<\/strong> – keeps metadata of each post on the site, such as custom fields.<\/li>\n\n\n\n
  6. wp_posts<\/strong> – stores data from articles, custom post types, pages, and navigation menu items.<\/li>\n\n\n\n
  7. wp_termmeta<\/strong> – stores metadata of the terms.<\/li>\n\n\n\n
  8. wp_terms<\/strong> – contains the WordPress terms for each post tag and category.<\/li>\n\n\n\n
  9. wp_term_relationships<\/strong> – maintains the association between posts and terms in the wp_terms table.<\/li>\n\n\n\n
  10. wp_term_taxonomy<\/strong> – describes the taxonomy for each category, link, and tag in the wp_terms table.<\/li>\n\n\n\n
  11. wp_usermeta<\/strong> – keeps the metadata of each registered user on a WordPress site.<\/li>\n\n\n\n
  12. wp_users<\/strong> – contains the list of users, including their usernames, passwords, and email accounts.<\/li>\n<\/ol>

    Each table stores specific data about your site. When you make website changes, the data on these tables can add and pile up. That’s why you should learn how to access and optimize your WordPress databases<\/a>.<\/p>

    \n\n\n

    \n
    \n If getting quality web hosting is your priority, check out our plans starting at $1.99\/month.<\/span>\n Get Quality Hosting<\/a>\n <\/div>\n <\/div>\n\n\n\n\n\n<\/p>

    How to Access a WordPress Database<\/h2>

    When setting up the platform manually, you’ll have to create a brand new WordPress database. To speed up the process, consider looking for a hosting provider with automatic installation.<\/p>

    Our WordPress hosting services<\/a> let you install WordPress in just a few clicks.<\/p>

    After the installation, access the database directly via your control panel, the hPanel<\/strong>:<\/p>

      \n
    1. Go to Hosting <\/strong>-> Manage<\/strong>.<\/li>\n\n\n\n
    2. Scroll down to the Databases <\/strong>section.<\/li>\n\n\n\n
    3. Select MySQL Databases <\/strong>to view and create databases and users.<\/li>\n<\/ol>
      \"The<\/a><\/figure>
        \n
      1. Click Enter phpMyAdmin<\/strong> to access the database.<\/li>\n<\/ol>

        Alternatively, access phpMyAdmin using our unique direct link:<\/p>

          \n
        1. Open Databases<\/strong> -> phpMyAdmin<\/strong>.<\/li>\n\n\n\n
        2. Click on the link at the top of the screen.<\/li>\n<\/ol>
          \"phpMyAdmin<\/a><\/figure>
            \n
          1. Once the login screen appears, fill in your MySQL database username and password.<\/li>\n<\/ol>

            How to Manage a WordPress Database?<\/h2>

            After you click on the direct link or the Enter phpMyAdmin<\/strong> button, this interface will appear:<\/p>

            \"The<\/a><\/figure>

            Here, you can access the default WordPress database tables and perform basic management tasks, such as:<\/p>