Skip to content

This tutorial describes how to create a database using cPanel, a popular platform management utility offered by many websites hosts. MySQL databases are generally confusing to many. The technique we will describe can be used by anyone websites an application that requires MySQL.

 

What is a database?

A database is a collection of organized data. E.g, WordPress stores all your pages, posts, categories and user data in a database.

MySQL is a database management system (Data Base Management System). It is software that allows you to create, update, read and delete data in a database. A single MySQL installation can manage any number of stand-alone databases. 

There are many alternatives, but MySQL has become popular for several reasons:

 

  • it is free open source software. It is now owned Oraclebut there are also open options compatible with MySQL, such as MariaDB.
  • has become synonymous with PHP, the programming language that is one of the most used on websites-ui that runs WordPress. Both PHP and MySQL emerged in the mid-1990s, when Internet development was in its infancy.
  • adopts the Structural Query Language (Sstructured QUery Language), a fairly standard language for creating data structures and data.
  • It is fast, easy to install and has many other development tools.

 

How do applications access the database?

Applications like WordPress-a access their data through a connection to the database. In the case of MySQL, WordPressPHP code can only establish a connection when it knows:

 

  • the address where MySQL is installed
  • the name of the database to access
  • the user ID and password required to access that database

 

How is the data stored?

MySQL and other SQL databases store data in relational tables.

For example, you may have a set posts (articles). Each post will have unique information, such as the title and body of the text. It will also have information used in other posts, such as category and author details. Instead of repeating the same data over and over again, we create separate tables:

 

  • author table containing ID, author name and other details
  • a table of categories containing the ID and name of the category
  • a post table containing the title of the article and the text of the text. Indicates the author and category by reference to the associated ID number.

 

SQL databases implement safeguards that guarantee data integrity. You cannot refer to an author ID that does not exist or delete a category used by one or more articles.

These table definitions and rules make up the database schema. A set of SQL statements is executed during installation WordPress-and when creating this scheme. Only then are the tables ready for data storage.

 

How to create a database?

Hosts that use cPanel provide websites address (such as https://site.com/cpanel) and user ID and password to access. Keep these details safe. 

If you are looking for a provider that supports cPanel, give it a try DreamWeb, our hosting provider of choice. All their plans support cPanel, and the control panel is organized for easier navigation and use.

Select an option MySQL Database Wizard and follow the next corks that are pretty intuitive.

You are then asked to create and name your new database.

The name prefix is ​​usually used in the name, and the appropriate database name is entered below. Enter an appropriate name, such as blog or WordPress and press the option NextStep.

The next step is to create and define a database user.

Note that the username will often have the same prefix as the database, in this case sitename_username.

cPanel will ensure that you enter a strong password, which must be strong, in order to protect access as much as possible and increase the security of the database. Therefore, ensure that your username and password are stored in a safe place.

Then you determine the privileges of access to the user, that is, everything that he will be able to change and update in the database. In these few steps, you used cPanel to create a new MySQL database in WordPress applications.

 

Pfeel our News & Stories aside, we have prepared for you a number of educational texts.

Made by Nebojsa Radovanovic - SEO Expert @Digitizer

Sign Up Now.

Follow.

Chat.

Contact Form.

    Name and surname*
    E-mail*
    Do you want to leave a mobile phone number?*
    Mobile phone number
    Company/Organization*
    Website
    What does your company/organization need?
    Do you know what results you want to achieve?*
    What results do you want to achieve?


      Name and surname*
      E-mail*
      Do you want to leave a mobile phone number?*
      Mobile phone number
      Company/Organization*
      Website
      What date would you like to make an appointment?
      What time?


        Name and surname*
        E-mail*
        Do you want to leave a mobile phone number?*
        Mobile phone number
        Company/Organization*
        Website
        Do you know what results you want to achieve?*
        What results do you want to achieve?


        Mobile & Email.

        Links.