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.

How to Install a WordPress Theme

WordPress is the most popular Content Management System (CMS) in the world. It is used by millions of websites as a robust, high-performance platform for publishing all forms of content.

One of the advantages of using WordPress as your CMS, is that you will have access to thousands of plugins and themes, that will enable you to change the functionality and appearance of your website, simply and quickly.

This knowledge base article covers the process of installing and activating a new WordPress theme.

Step one – procure the theme and upload it to your website

  1. Find a theme you like and download it to your computer. The theme will be compressed as a .ZIP file.
  2. Decompress the .ZIP file. It will create a folder with the same name as the .ZIP file. Inside this folder, you will find all of to components of the theme. PHP code, images, scripts, etc.
  3. Upload this folder to your hosting account using FTP. The location that you need to upload it to, will depend on where you installed WordPress. Look under your /public_html/ folder, if you see a folder named wp-content, WordPress is installed in your root. If you don’t see this folder, you will need to locate the subfolder WordPress is installed in. Check each subfolder; you are looking for one that contains the wp-content folder. When you find it, drill down to the wp-content folder, and then the themes folder. You need to upload the folder that the theme decompressed into, to this folder. A typical folder structure, once you have completed this, would look this: /public_html/wp-content/themes/mynewtheme/

Step 2 – activating the new WordPress theme

  1. Log in to the WordPress administration dashboard at http://domainname/wordpressfolder/wp-admin/ if you installed WordPress outside of the /public_html/ folder or simply http://domainname/wp-admin/ if you did install WordPress in the /public_html/ itself.
  2. Click Appearance, in the menu on the left.
  3. You will now see all of the themes that you have available to use. Locate your new theme and click its Activate button.
  4. Your new theme will now be active. If you have any caching plugins activated, you may need to clear your site cache to see the new theme working.

Useful links:

The official WordPress Codex entry explaining themes and how they work

If you are concerned about the security of your adult content related website, and would like to make sure that it is protected, we offer specific website security related products. We can also provide you with SSL certificates.

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.