Archive

How to Upgrade MySQL Within cPanel or Using SSH

You can think of cPanel as your hosting nerve centre. You can accomplish anything you need to do within cPanel. One function of cPanel is managing MySQL databases and users. In this knowledgebase article, we are going to cover how to check the version of MySQL you are running, and also how to upgrade it to version 5.x.

Checking Your Current MySQL Version

First, log in to your cPanel, and then choose the Server Configuration option, and then Tweak Settings. You will find MySQL in this section, and a radio button that allows you to select 4.x or 5.x. Whichever is selected is the version you are using.

Alternatively, you can log in using SSH and check the file /var/cpanel/cpanel.config and within this file, you will see the MySQL version in use.

How to Choose Your MySQL Version

There are two options here. You can either use the previously mentioned radio button to select the new MySQL version, or you can log in via SSH and edit the file /var/cpanel/cpanel.config changing the MySQL version to 5.x.

Completing the MySQL Upgrade

Once you have changed your MySQL version, you need to perform a final step. Log in using SSH and run the following scrips:

/scripts/upcp –force

/scripts/mysqlup –force

It may take a short time for the MySQL upgrade to complete. Once it does, check your current MySQL using the methods outlined above to ensure the upgrade was successful.

Useful links:

The official cPanel knowledgebase article on how to upgrade MySQL and MariaDB

If you have outgrown your shared hosting plan, 365hosts can provide you with a simple upgrade path, using either one of our VPS hosting plans, or your own dedicated server. Call us to talk over your options, so we can advise you on the best plan for your needs.

Configuring a Subdomain to Use a Different IP Address

If your hosting package provides you with more that one IP address, you would be able to use a separate IP address for an additional domain, or a subdomain of your current domain. A subdomain looks like this:

subdomain.maindomain.com

In this knowledgebase article, we are going to cover the process of adding a DNS entry so that a subdomain relates to a separate IP address. Don’t worry; this is much easier than it sounds.

First, you need to log in to cPanel. Once you have, you will see over on the left-hand side, the DNS Functions option. Choose this option, and you will then be able to see a further option, Edit Zone. Click this option.

Now, we need to add the new DNS entry. In this case, it will be ab A record. You should now see a list of all of your DNS records, and down at the bottom, the text “Add New Entries Below This Line”. Right below this, we will be filling in the fields to add your new A record.

In the first field, put the name of the subdomain. For example; blog to create a blog.maindomain.comsubdomain. Now, use the drop-down box to select the record type as an A record. When you select A record, an additional box will appear to the left. In this box enter the new IP address you want the subdomain to point to. Save your changes and exit.

Now, whenever somebody types your new subdomain into the URL bar of their browser, for example; blog.maindomain.com it would resolve DNS using this new A record, which points to your new IP address.

Useful links:

A Wikipedia article that gives an overview of every type of DNS record

If you currently use a shared hosting package, and you need to start hosting additional domains or subdomains on separate IP addresses, you might like to consider upgrading to one of our VPS hosting plans.