Changing MySQL User Password Using WHM/cPanel

This is the recommended method when performing a MySQL user password change when your server contains a cPanel installation.

1. Login to your WHM/cPanel and search for “Change MySQL® User Password“.

   

2. Select the MySQL user you wish to change the password.
3. Ensure to type a password with a strength score of at least 80%, as shown below and press the “Change Password” once completed.

Changing MySQL User Password Using the Command Line Interface 

The following steps will describe the process involved in changing the MySQL user password via the command line once you’ve logged into your server via SSH or by using the Console feature in the customer portal.

1. Login to the server as the “root” user.
2. Type the command mysql -u root -h localhost -p to login to MySQL as the “root” user.
3. Enter the “root” user MySQL password to login.
   1. If you are unsure of what the “root” user password is, you can use the command my_print_defaults -s client to view it in the main command prompt.
4. Now that you are logged in to MySQL as “root” user.

   

5. Run command SELECT user FROM mysql.user; to view a full list of available users.

   

6. Use the following command to alter the password ALTER USER ‘pascalsuissa’@’localhost’ IDENTIFIED BY ‘MyNewPasswordis1234!’;
   1. “pascalsuissa” is the username.
   2. “MyNewPasswordis1234” is the password.

7. Once the command has completed running, the prompt will display a “Query OK” message, indicating that the password change is now complete.

   

The post Resetting MySQL User Password appeared first on Hivelocity Hosting.

In this article, Skeleton Directories in Linux, we will review each of the parameters and directories involved with the skeleton directory. 

Skeleton Directory Overview in A Linux System

The skeleton directory (/etc/skel) provides the backbone or skeleton of what any new account /home/<username> directory would look like. For example, if there are 3 directories in /etc/skel, then those directories would populate upon each and every new account that is being created.

1. As shown above, we are viewing the directory with ls /etc/skel which shows no directories within.
2. Create the required directories with the mkdir command, “Documents”, “Videos”, and “Downloads”.
3. Use the ls command to verify that the newly created directories are present.
4. When creating a new user, such as ‘pascal’ using the command useradd pascal, the user’s home directory will be located at /home/pascal/.
5. View the home directory of the new user using ls /home/pascal in which the new directories will appear.

As seen in this article, skeleton directories are a useful tool for organizing the structure and layout of a project or user. Skeleton directories can help developers and collaborators to understand the purpose and function of each component, as well as to avoid duplication and confusion. Skeleton directories can also facilitate the automation and testing of the project, by making it easier to locate and execute the relevant scripts and commands.

The post Skeleton Directories in Linux appeared first on Hivelocity Hosting.

If you don’t have access to WHM, or if you’re more familiar with cPanel and prefer to use it for modifying DNS records, you can do so using cPanel’s DNS Zone options. For instructions on creating and editing DNS zones in cPanel, check out our article on How to Create DNS Records in cPanel.

Creating DNS Records in WHM

Finding the Domain’s DNS Records

To create DNS records using WHM, follow these steps:

1. First, you will need to log in to the WHM control panel using your username and password. You can access your WHM panel on your cPanel server by entering the following URL into your web browser,

   https://(my server’s IP address):2087

   or, if A records have already been propagated for your server, you can use

   https://mydomain.com:2087.

2. Once logged into WHM, navigate to Home -> DNS Functions -> DNS Zone Manager. This will open a new page.
3. On the new page that opens, you will see a list of all the zones already on the server. Find the domain you wish to edit, select it, and click the “Manage” button.
   *Note: If you have a large number of accounts on your server, you can use the text box to filter domains.

   

4. After selecting your desired domain and clicking the “Manage” button, a new page will open where you can edit and create records.

   

Creating and Editing DNS Records 

1. Starting at the top of the page as per the previous section, you will see all the records currently in place for your selected domain. If you need to edit any of these records, you can do so here by pressing the “Edit” button to make the required changes.
   1. By default, cPanel will include records for DKIM and SPF, unless set otherwise on the server, but will list these records as TXT files.
2. To add additional DNS records, proceed to press on the “Add Record” button at the top of the page and select the desired record type.

   

3. A new line will be created with the record type of choice for you to fill it out as needed.

   If you are looking to add SPF or DKIM records to the domain, you must select the TXT option. Then, fill out the records with the appropriate information during creation.

   1. If you are unsure what type of record you need to create or are unclear about their inherent differences, check the terminology section in our DNS Configuration Guide.
   2. One of the most common mistakes in creating or editing records is not including the trailing ” . ” at the end of the record. All records with top-level domains should include the trailing period at the end of their domain names.

      

4. Once you’ve added/edited a record, click “Save Record” to finalize the changes.

   A prompt will display at the top right of the webpage for a successful change alert. If the change fails, it will show an error message, as demonstrated in the two images below.

   

   

5. At this point the DNS records are set and ready to go. 

Further Assistance

For any further assistance involving DNS records within WHM, do not hesitate to reach out to the Hivelocity Support team. You can contact them via chat, support ticket, or by phone at 888-869-4678.

The post How to Create DNS Records in WHM appeared first on Hivelocity Hosting.

*NOTE: this method requires the user to have root access to the WHM account associated with their cPanel account. If you do not have access to WHM, you may need to contact your hosting provider for more information on how to make this change.

Converting an Addon Domain to a Primary Domain

By following these 10 easy steps, you can convert any addon domain into a primary domain in no time at all:

1. First, log in to WHM with root user.
2. Once logged in, on the left side panel, search for the Transfers option and click on Convert Addon Domain to Account.
3. On the right side, you will now see a list of addon domains hosted on your server. Using the search/filter window, you can search for the specific addon domain you want to convert to a primary domain.
4. Once you’ve located the addon domain you want to convert, select it, and then click Convert.
5. On the next screen, enter the contact email for the new account and select the package you want to assign for this new account. Normally, you can leave the option to Preserve Account Ownership as is.
6. Scroll down the page until you see the Selection details option for the addon domain. By default, the conversion process will select all the data, DNS records, emails, databases, subaccounts, and FTP accounts and will copy them into the primary account. If you’d like to customize the data selected, you can do so by clicking on the Configure button.
7. Once you’re ready, scroll down the page and click the Start Conversion button.
8. On the next screen, you’ll see that the conversion is being processed. The time required will depend on the volume of Email accounts, FTP Accounts, Sub domains, and other data being converted.
9. Once the conversion process has finished, you can click on the Details button to view complete information regarding the conversion process.
10. To verify the conversion was done successfully, on the left side menu click on List Accounts. If your addon domain has converted successfully, you’ll see the new primary domain account listed here.

And there you have it!

Popular Links

Looking for more information on cPanel? Search our Knowledge Base!

Interested in more articles about Control Panels? Navigate to our Categories page using the bar on the left or check out these popular articles:

• How to Fix Invalid cPanel License Error When the IP is In Fact Licensed
• How to Increase PHP Upload Limit on a cPanel Server
• How to Add a Subdomain in Plesk 12

Popular tags within this category include: cPanel, WHM, Plesk, DirectAdmin, and more.

Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.

The Hivelocity Difference

Seeking a better Dedicated Server solution? In the market for Private Cloud or Colocation services? Check out Hivelocity’s extensive list of products for great deals and offers.

With best-in-class customer service, affordable pricing, a wide-range of fully-customizable options, and a network like no other, Hivelocity is the hosting solution you’ve been waiting for.

Unsure which of our services is best for your particular needs? Call or live chat with one of our sales agents today and see the difference Hivelocity can make for you.

The post How to Convert an Addon Domain to a Primary Domain in cPanel appeared first on Hivelocity Hosting.

Enabling Manage AutoSSL in cPanel

To manage the AutoSSL feature in cPanel, just follow these steps:

1. First, log in to WHM as the root user, using your username and password.
2. On the left side panel, under the SSL/TLS menu, click the option to Manage AutoSSL.
3. On the right side panel, you will see that this feature is disabled by default.
4. To enable the feature, select the cPanel (powered by Comodo) radio button and click Save.
5. You will receive a notification from cPanel that the feature has been enabled.

And there you have it!

Popular Links

Looking for more information on cPanel? Search our Knowledge Base!

Interested in more articles about Control Panels? Navigate to our Categories page using the bar on the left or check out these popular articles:

• How to Fix Invalid cPanel License Error When the IP is In Fact Licensed
• How to Increase PHP Upload Limit on a cPanel Server
• How to Add a Subdomain in Plesk 12

Popular tags within this category include: cPanel, WHM, Plesk, DirectAdmin, and more.

Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.

The Hivelocity Difference

Seeking a better Dedicated Server solution? In the market for Private Cloud or Colocation services? Check out Hivelocity’s extensive list of products for great deals and offers.

With best-in-class customer service, affordable pricing, a wide-range of fully-customizable options, and a network like no other, Hivelocity is the hosting solution you’ve been waiting for.

Unsure which of our services is best for your particular needs? Call or live chat with one of our sales agents today and see the difference Hivelocity can make for you.

The post How to Enable the Manage AutoSSL Feature in cPanel appeared first on Hivelocity Hosting.

MultiPHP Manager is a new tool introduced to cPanel alongside EasyApache 4. It allows users to select which versions of PHP run on their sites on a per-domain level. For instance, if your server is running PHP 5.6 as it’s default PHP version but your website requires PHP 7, instead of changing the PHP version across your entire server, you can use MultiPHP manager to change the PHP version for only the specific domain you’d like to update.

*Note: To use MultiPHP Manager you must upgrade EasyApache to version 4.

Changing PHP Versions with MultiPHP Manager

To change the PHP version on one of your domains, just follow these steps:

1. First, log in to WHM as the root user using your username and password.
2. Once you’ve logged in, on the left side menu, search for Multi, then under the Software section, click on MultiPHP Manager.
3. On the right side panel, you will see a list of websites hosted on the server. Locate and select the website for which you’d like to change the PHP version.
4. From the PHP Version dropdown window, select the PHP version you want to configure for the website.

   *Note: the versions available to you are determined by which versions are enabled in EasyApache 4.

5. Once you’ve selected your desired PHP version, click Apply to finalize your changes.
6. You should now be able to see that the PHP version for the domain you’ve selected has been changed to your PHP version of choice.

And there you have it! If there are other domains you need to change the PHP version for as well, simply repeat the above steps as needed.

Popular Links

Looking for more information on cPanel? Search our Knowledge Base!

Interested in more articles about Control Panels? Navigate to our Categories page using the bar on the left or check out these popular articles:

• How to Fix Invalid cPanel License Error When the IP is In Fact Licensed
• How to Increase PHP Upload Limit on a cPanel Server
• How to Add a Subdomain in Plesk 12

Popular tags within this category include: cPanel, WHM, Plesk, DirectAdmin, and more.

Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.

The Hivelocity Difference

Seeking a better Dedicated Server solution? In the market for Private Cloud or Colocation services? Check out Hivelocity’s extensive list of products for great deals and offers.

With best-in-class customer service, affordable pricing, a wide-range of fully-customizable options, and a network like no other, Hivelocity is the hosting solution you’ve been waiting for.

Unsure which of our services is best for your particular needs? Call or live chat with one of our sales agents today and see the difference Hivelocity can make for you.

The post How to Change PHP Versions for a Website Using MultiPHP Manager in cPanel appeared first on Hivelocity Hosting.

Repairing Corrupted User Data Files

To rebuild a corrupted user data file within cPanel, follow these steps:

1. First, log in to your WHM/cPanel server as the root user using your username and password.
2. Next, you’ll need to locate the user data files, which can be found at /var/cpanel. Make sure the userdata directory is present on the server.
3. If the directory does exist, move it or rename it with the mv command. It should look something like this:

   mv /var/cpanel/userdata /var/cpanel/userdata_backup
   

4. Now, create a new userdata directory with the command mkdir:

   mkdir /var/cpanel/userdata
   

5. Now that we have a new userdata directory created, in order to rebuild the userdata files for all the accounts hosted on your cPanel server, run the script userdata_update with the –reset flag. This will rebuild the userdata files for all accounts hosted on your cPanel server.

   /usr/local/cpanel/bin/userdata_update –reset
   

6. Next, you’ll need to fix the permissions for the newly generated user data files which can be done by running the command:

   /usr/local/cpanel/bin/fix_userdata_perms
   

7. Since you’ve generated a new userdata file, you will need to update the system’s cache. This can be done using the command:

   /scripts/updateuserdatacache
   

8. Now, rebuild the apache configuration in order to use the newly rebuilt userdata files with the command:

   /scripts/rebuildhttpdconf
   

9. Lastly, restart the apache service with the command:

   /scripts/restartsrv_httpd

And there you have it!

Popular Links

Looking for more information on cPanel? Search our Knowledge Base!

Interested in more articles about Control Panels? Navigate to our Categories page using the bar on the left or check out these popular articles:

• How to Fix Invalid cPanel License Error When the IP is In Fact Licensed
• How to Increase PHP Upload Limit on a cPanel Server
• How to Add a Subdomain in Plesk 12

Popular tags within this category include: cPanel, WHM, Plesk, DirectAdmin, and more.

Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.

The Hivelocity Difference

Seeking a better Dedicated Server solution? In the market for Private Cloud or Colocation services? Check out Hivelocity’s extensive list of products for great deals and offers.

With best-in-class customer service, affordable pricing, a wide-range of fully-customizable options, and a network like no other, Hivelocity is the hosting solution you’ve been waiting for.

Unsure which of our services is best for your particular needs? Call or live chat with one of our sales agents today and see the difference Hivelocity can make for you.

The post How to Rebuild Corrupted User Data Files in cPanel appeared first on Hivelocity Hosting.

1. Login to WHM and issue a CSR for the server’s hostname.

2. Now that you have the CSR, login to your SSL certificate provider account and provide the CSR. Note – Each SSL provider has different portal , so you have to follow the step according to the provider to get the SSL .Your SSL provider will mail you the SSL certificate against the CSR.

3. Once you receive the SSL , go back to the WHM and at your left hand side pane search for “Service Configuration ” section and click on “Manage Service SSL certificates”

4. Select all services to where you need to install certificate, and paste the certificate in Certificate section.

5. Copy and paste the previously save CSR, Private Key and the Certificate in respective windows.

6. Now click on Install and the SSL certificate will be installed.

7. After finishing installation it will prompt for restart cPanel service, so just click on Proceed button.

8. At this stage you have successfully install a trusted ssl certificate in your WHM panel. To verify it navigate to Home » Service Configuration » Manage Service SSL Certificates and click on Certificate Details link in each service and view the details.

The post How to install a CA issued SSL (non self-signed) for cPanel services appeared first on Hivelocity Hosting.

This article provides solutions should you log in to your WHM/cPanel and find a ‘trial license’ message or find yourself unable to log in due to an invalid or expired license.

When faced with an invalid license error, there are multiple possible causes. These include:

1. cPanel license expiration
2. Changes in the main IP of the server
3. Your license not being updated

To determine what is causing the error, you’ll first need to check on the status of your cPanel license.

Checking Your cPanel License

To check for the cause of the above issues, you’ll first need to make sure you have an active cPanel license for the server IP. You can check the status of your cPanel license using cPanel’s official license verification tool.

To start, copy and paste your server’s IP address and click Verify. The next screen will show you the status of your cPanel license.

If you find that the cPanel license status is invalid for your server’s primary IP address and you’re receiving licensing for cPanel with us or your service, we recommend issuing a support ticket or emailing us directly at support@hivelocity.net confirming your findings. This is generally a very quick resolution unless the IP has been licensed from another party.

Fixing an Invalid cPanel License Error

If you see the cPanel license status is active, you can use the commands below to fix the invalid cPanel license error. Alternatively, if you see a trial period in effect on your server, you can simply wait until the next day as this script runs on a nightly basis automatically.

1. Login to the server with root user with either Secure shell client ( SSH ) or Putty or utilize `WHM | https://YourServerIP:2087 -> Terminal`

2. Run the following as root on the server:

`/usr/local/cpanel/cpkeyclt --force`

After executing the command, it will show you that the license status has been updated.

Now you should be able to login to WHM and navigate through it.

Popular Links

Looking for more information on cPanel? Search our Knowledge Base!

Interested in more articles about Control Panels? Navigate to our Categories page using the bar on the left or check out these popular articles:

• How to Enable Docker Support in Plesk Onyx
• How to Increase PHP Upload Limit on a cPanel Server
• How to Add a Subdomain in Plesk 12

Popular tags within this category include: cPanel, WHM, Plesk, DirectAdmin, and more.

Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.

The Hivelocity Difference

Seeking a better Dedicated Server solution? In the market for Private Cloud or Colocation services? Check out Hivelocity’s extensive list of products for great deals and offers.

With best-in-class customer service, affordable pricing, a wide-range of fully-customizable options, and a network like no other, Hivelocity is the hosting solution you’ve been waiting for.

Unsure which of our services is best for your particular needs? Call or live chat with one of our sales agents today and see the difference Hivelocity can make for you.

The post How to Fix Invalid cPanel License Error When it is Licensed appeared first on Hivelocity Hosting.

Connect to the source server via SSH terminal

Use an SSH terminal application like Putty or another OpenSSH client to connect to your server with the root credentials provided in your servers welcome letter.

You will need:

• Server IP address
• Server SSH port (22 is default — if you see Connection refused error, you are using the wrong SSH port)
• User: root or sudoer user
• Password

If you are unsure what your source server credentials are, please contact the hosting providers support for assistance. If it’s a server with us, please request a password reset through your my.hivelocity.net portal by issuing a ticket to general support or email us support@hivelocity.net.

1. Package the account on source server

Perform the following while connected to your server via SSH terminal application.
Replace cpaneluser with the cpanel account username you are trying to package
/scripts/pkgacct cpaneluser This should effectively create a cpmove-cpaneluser.tar.gz archive file of your entire cpanel account.

2. Transfer the cpmove archives to your destination server

You can use any SSH FTP SFTP client such as FileZilla to move the archive files to your destination server.

To transfer via commandline, you can use rsync from the source server to push the files to the new servers /home directory
Replace PORT#DESTSERVER with the port number such as 22 or XXXX if custom
Replace CPANELUSER within /home/cpmove- entries to migrate individual archives or you can use /home/cpmove-* in the second example below
Replace DESTINATIONIP with your destination server IP address e.g. 155.188.99.111
rsync -vrplogDtH -e “ssh -p PORT#DESTSERVER” /home/cpmove-CPANELUSER.tar.gz root@DESTINATIONIP:/home/cpmove-CPANELUSER.tar.gz Example 2 – transferring all cpmove files rsync -vrplogDtH -e “ssh -p PORT#DESTSERVER” /home/cpmove-*.tar.gz root@DESTINATIONIP:/home/

3. Restore the packages on the destination server

After all of the archives have been transferred, you then need to connect to your destination server via SSH terminal and perform for each account: /scripts/restorepkg cpaneluser After performing the above for each account, you should now have restored packaged to the destination server

If you thought that was helpful, check out this article on How to mount your cloud storage drive on your CentOS, RHEL or Fedora systems from our Impressive Support staff

Back to Top

The post How to perform a manual cPanel migration (Updated) appeared first on Hivelocity Hosting.

How to use Cloud Storage to backup up your cPanel Server.

First login to https://my.hivelocity.net go to Services & Hardware, next click the Cloud Storage button at the top. Once you are in the Cloud Storage page you will see Login Details.

You will need your Login Details to setup cPanel backups so keep them handy for step #4.

1. Login to WHM on your server or VPS. https://your-server-ip:2087/

2. Click Backup

3. Click Backup Configuration

4. From this page you can choose when your server runs the backups, You can choose your preferences here, when you get to the bottom set up an SFTP Destination and use the settings from the image below, remember to change the username and password to the ones listed in myVelocity.

5. When you’re done make sure to click save and validate to make sure your settings are correct and functioning properly. Also be sure that the new backup destination is enabled.

Note: If for any reason the validation does not work and your settings are correct be sure to open port 22 in your servers firewall.

The post cPanel Backup Cloud Storage How To appeared first on Hivelocity Hosting.