MySQL is one of the best, open source communities of Relational Database Management System (RDBMS). It makes use of a Structured Query Language (SQL). It has gained popularity for its ease of adding, managing, and accessing database content. Then, there are also its other features, including its tried and tested reliability, ease of use, flexibility, and speedy processing. As a plus, you can get it for free.
You can also use MySQL client when you want to use WordPress as your content management system using your cPanel account. Here are the steps you need to follow:
Create a MySQL Database in Your cPanel First
Before you can get WordPress via this RDBMS, you first need to create a database for MySQL in your cPanel account. You can do this via the MySQL Databases menu you will find in your cPanel interface.
Downloading WordPress to cPanel via MySQL Client
Since you now have all the prerequisites, you can now get WordPress for your cPanel. You can easily and speedily create databases and users of MySQL/MariaDB through shell execution of mysql.
To give you an idea on what to expect, check the example syntax below, wherein the dollar sign represents the command prompt:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5340 to server version: 3.23.54
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> CREATE DATABASE databasename;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON databasename.* TO “wordpressusername”@”hostname”
-> IDENTIFIED BY “password”;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
What All these Mean
In this sample syntax, it shows the following:
There you have it, as long as you follow these steps, you can have WordPress up and running through MySQL under your cPanel account.