The mysql_upgrade command [MySQL/MariaDB]

It is recommended to run this command every time to update your MySQL/MariaDB from one major release to another. For example when upgrading from MySQL 5.7 to MySQL 8; MariaDB 10 to MariaDB 11. It checks all the databases(with all the tables) for any incompatibilities. It also updates the system tables with new privileges or options that might have been added in the new version.

The command with options is:

mysql_upgrade [--force] [--user=# --password
--host=hostname --port=# --socket=#
--verbose] OTHER_OPTIONS]

Simply run the command in shell:

root@www [/home]# mysql_upgrade


Share this post:

WHM Tweak Settings

WHM Tweak Settings section is where you will find many, many options for your cPanel server.

whm tweak settings

To access and modify WHM Tweak Settings:

  1. Access WHM
  2. Go to Server Configuration >> Tweak Settings
  3. Here you will have some tabs – Compression, Security, PHP etc. Modify the option(s) you want and click the Save button.
Notice that you can search the for specific settings via the Find box.

The video tutorial for this article:

More info on

Share this post:

Statistics Software Configuration

Probably not many users use the Statistics Software (Analog/Awstats/Webalizer) that come with cPanel, but you may want to allow this option on the server. In the last years, most of the sites use Google Analytics.

On the same WHM configuration page will be able to configure the Log/Bandwidth Processing Frequency.

whm statistics software configuration

To modify the Statistics Software Configuration:

  1. Connect to WHM
  2. Go to Server Configuration >> Statistics Software Configuration
  3. To see specific/all user’s statistics summary, go to the Statistics Status Summary and click the Go button.
  4. To process the stats for one user go to the Process Statistics for User section, select the user from the drop-down list box and click the Go button.
  5. To select the stats software to allow on the server go to Generators Configuration, choose the stats software you want and click the Save button.
  6. To change the log/bandwidth processing frequency, go to Schedule Configuration, enter the interval and click the Change button.

The video tutorial for the tutorial:

Share this post:

Change root password in WHM

For security reasons is a very good idea to change your password often. You can change the root password via shell, but also via the WHM interface.

whm chnage root password

To change the root password in WHM:

  1. Log into WHM using your root credentials
  2. Navigate to Server Configuration >> Change Root Password
  3. Enter or Generate a strong password. (you can generate a max 18 char long password)
  4. Click the Change Password button. You will see a confirmation message: The system successfully updated the root password. The following service passwords changed: system
Notice that only the user root can change the root password. A reseller with “all privileges” can’t change the root password. The user will get an error message API failure: (XID aexhaf) You do not have a user named “root”.
Tip: Use the passwd command to change the password from command line.

The video tutorial for this article:

Share this post:

Change server time via WHM

After a WHM/cPanel installation, you may want to change the server time. Of course, you can do this from the command line, but you can also do this via the WHM interface.

whm server time

To change your dedicated/virtual server time via the WHM interface:

  1. Connect to your WHM installation
  2. Go to Server Configuration >> Server Time.
  3. Now select the time from the drop-down list box and click the Change TimeZone button to apply it. You will see a confirmation message like Local timezone has been set to America/New_York.
  4. Restart the server via System Reboot >> Graceful Server Reboot
cPanel recommend you to restart the server after each time zone modification: To ensure consistency, we strongly recommend that you reboot the server after you change the time zone.

There is also a button to sync the server time. Use this to sync the time with the time server. Notice that this will not work on virtual servers – you will get a warning message Container environment detected – rdate skipped.

The video tutorial for this article:

Share this post:
Page 1 of 9
1 2 3 9