Description: A database is a structured, organized set of data.
WordPress uses MySQL as its database management system.
MySQL is a software used to create databases, store and get data when requested.
MySQL is also an open source software, just like WordPress and works best with other popular open source software, such as Apache web server, PHP, and Linux operating system.
To install WordPress you need a MySQL database.
Database Tables: Databases have tables which are like sections or cabinets in your database system.
Each table has columns and information is stored as rows.
Each row has a field for each column in the table.
Description of all the tables available in the database of the wordpress
wp_commentmeta : This table contains meta information about comments posted on a WordPress website.
The table has four fields meta_id, comment_id, meta_key, and meta_value.
wp_comments : As the name suggests this table contains your WordPress comments. It contains the comment author name, URL, email, comment, etc.
wp_links : To manage blogrolls created by earlier versions of WordPress or the Link Manager plugin.
wp_options : This table contains most of your WordPress site-wide settings such as site URL, admin email, default category, posts per page, time format, and much much more. The options table is also used by numerous WordPress plugins to store plugin settings.
wp_postmeta : This table contains meta-information about your WordPress posts, pages, and custom post types.
Examples of post meta information would be which template to use to display a page, custom fields, etc.
wp_posts : The name says posts, but actually this table contains all post types or should we say content types. This table contains all your posts, pages, revisions, and custom post types.
wp_termmeta : This table allows developers to store custom metadata for terms under their custom taxonomies.
wp_terms : WordPress has a powerful taxonomy system that allows you to organize your content. Individual taxonomy items are called terms, and they are stored in this table.
wp_term_relationships : This table manages relationship of WordPress post types with terms in wp_terms table.
wp_term_taxonomy : This table defines taxonomies for terms defined in wp_terms table.
wp_usermeta : Contains meta information about registered users on your website.
wp_users : Contains user information like username, password, user email, etc.
Steps to create the database in cPanel:
Step 1: Login to the cPanel using username and password.
Step 2: Goto databses and click on MYSQL Databases.
Step 3: Click on Create database.
Step 4: Just put down the database name and click on the create database.
Step 5: Create user with its password add after that add it to the database.
Step 6: Now goto phpMYAdmin from there you can import the database of the website to the particular domain.
In case you wish to delete your database, you can follow this article : Steps to delete the Database in cPanel
