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.
Step 2 – Scroll down to the “SQL services” and click on the “MySQL/MariaDB upgrade”. A new interface will appear.
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
Step 4 – And click ‘Next’. A new interface will appear. That list warnings about your database upgrade. Read them carefully.
Step 5 – Select the checkboxes to acknowledge that you are read and accepted each warning.
Step 6 – And click ‘Continue’. Another interface will appear.
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.
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.
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.
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”
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.
Step 12 – Click “Ok”.
Step 13 – Click “Configure PostgreSQL” to return to the previous menu. Then click “Create users” that your cPanel users to postgre.
Step 14 – A confirmation message will appear.
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.
Step 16 – Click change password and we are done.
Visit: Hostripples!
