Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Steps For Configuring Primary MySQL Database on Your Server

Database configuration

In this blog we are going to configure the primary MySQL database on your server. You all know that MySQL is a Relational Database Management System. CPanel and WHM’s interfaces support MySQL or MariaDB. MariaDB is one of the most popular database servers. It is free and open source software.It also supports PostgreSQL but it takes a bit of efforts to install Postgre. We will step through that process, also when you select a database make sure that your application inside code run on that particular version , of MySQL, MariaDB or Postgre.

Follow the below steps:

 Step 1 – Let’s go ahead and login to WHM and here we are in the WHM home interface.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 2 – Scroll down to the “SQL services” and click on the “MySQL/MariaDB upgrade”. A new interface will appear.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 3 – You can choose between major releases of MariaDB and MySQL. The interface displays information about each type of database. You cannot downgrade your database to a lower version number.

This includes downgrades for MariaDB back to MySQL, so if you can convert to MariaDB it’s a one way street you cannot revert back to MySQL. Think about this carefully before you do it. Make your selection

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 4 – And click ‘Next’. A new interface will appear. That list warnings about your database upgrade. Read them carefully.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 5 – Select the checkboxes to acknowledge that you are read and accepted each warning.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 6 – And click ‘Continue’. Another interface will appear.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 7 – This interface asks you which type of upgrade you wish to perform.

Unattended: will rebuild apache and PHP for last saved defaults and will automatically update it any Ruby Gems you have installed rebuild apache and PHP.

Partially interactive: updates Ruby Gems, but will not rebuild apache and HP until you’re chosen to do so later.

Interactive: steps you the upgrade process. I am going to select unattended and let this process run all the way through.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 8 – Click “Continue” to continue. The interface will display a creepy ping pong green slide and a running log file.

Step 8 – Click “Continue” to continue. The interface will display a creepy ping pong green slide and a running log file.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

 A few minutes later it will display a confirmation message. Because it is a fresh install you will not have any Postgre databases to backup.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 9 – Login to your server via SSH as the Root user at the command line run following command:

# cd /scripts

# ./installpostgres

Step 10 – Then go back to the WHM interface and scroll down to “service configuration” and Click “Configure PostgreSQL”

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

It will take a while for the script to run, and then it will say it’s ready.

Step 11 – And click “install config”. A confirmation message will appear.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 12 – Click “Ok”.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 13 – Click “Configure PostgreSQL” to return to the previous menu. Then click “Create users” that your cPanel users to postgre.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 14 – A confirmation message will appear.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 15 – Once again click “Configure postgreSQL to return to the previous menu. Finally enter a new password and confirm it for the root user. Only use letters and not numbers, for this password. The password generation feature is probably a bad idea.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Step 16 – Click change password and we are done.

Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting

Visit: Hostripples!

USA Best Hosting Provider


Steps For Configuring Primary MySQL Database on Your Server, Hostripples Web Hosting
Vishwajit Kale
Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostripples, a company that aims to provide affordable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.