MySQL Databases interface to show MySQL as offline, Updating MariaDB to v10.2.35 or v10.3.26


Upgrading MariaDB to v10.2.35 or v10.3.26 causes the cPanel UI to not read the grants properly, which leads to cause select sites to be inaccessible and the MySQL Database page within the cPanel interface returns the following error.

More important to note that MariaDB should still be running, the cPanel error log should populate the string the UI is having issues reading:

[2020-11-05 07:37:27 +0000] warn [cpmysql] Error (Invalid grant string: SET DEFAULT ROLE 0 FOR '$user'@'$host'
) while parsing grant: SET DEFAULT ROLE 0 FOR '$user'@'$host' at /usr/local/cpanel/Cpanel/ line 956, <STDIN> line 1.
        Cpanel::Mysql::__ANON__(__CPANEL_HIDDEN__...) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/ line 118

cPanel has opened an internal case for their development team to investigate this further.

For reference, the case number is CPANEL-34745.

Follow this article to receive an email notification when a solution is published in the product. 

Before proceeding with these changes, we encourage you to backup your database in the event a restore is required.

To backup the MySQL database directory, the following command can be executed as root:

mysqldump mysql > /backup/mysql.sql

Once backup is complete, you can proceed with altering that database column order.

The following command performs the appropriate alterations for the database:

mysql -e "ALTER TABLE mysql.user MODIFY IF EXISTS password_last_changed timestamp DEFAULT CURRENT_TIMESTAMP NULL AFTER max_statement_time, MODIFY IF EXISTS password_lifetime smallint unsigned DEFAULT NULL AFTER password_last_changed, MODIFY IF EXISTS account_locked enum('N', 'Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL after password_lifetime;"

Apply the change by restarting the MariaDB service:


They should go into effect immediately. 

yum versionlock clear

Then run upcp to have the MariaDB packages updated:



What is an inode.

An inode is a data structure used to represent a filesystem object, which can be one of various things including a file or a directory. Each file has a single inode, even though they can have different names.

In other words, the number of inodes equals the total number of files and directories on your hosting plan. To ensure optimal performances, we limit the number of inodes upto 250 000 on most of the hosting plan.

Where can I see how many inodes I use.

To check how many inodes are used, log in to your cPanel. In the left sidebar, click on the Statistics icon. Under Disk Space, you will find Files Usage. This equals to your inode usage.

Steps to reduce inode usage.

There are several ways to reduce inode usage.

Delete useless files, old backups and websites

In your cPanel with the File Manager or through a FTP client, you can easily sort and delete files and directories that are not necessary. These can be scripts not in use, old development websites, unused image files…

Remove cache files

Some applications (such as Joomla, Drupal or WordPress for instance) generate a number of cache files used to improve performances. Verifying how big these cache files are and deleting them once in a while is a good practice. You should be able to remove cache files easily directly in the app.

Archive old emails

Every email on your hosting plan adds up to the total number of inodes. It is a good practice to archive older emails or to transfer them to your computer to limit their size on the server.

Also, it is necessary to check the catchall email address that can accumulates thousands of emails and therefore inodes.

Verify where error messages from scripts and CRON tasks go

If your CRON tasks generate error messages, they can be stored (and take a lot of room) on your server. It is important to check where the error messages go in order to reduce inode usage

How to enable Cloudflare with Railgun

A tutorial that will guide you about how to enable CloudFlare with Railgun for your website.

Cloudflare is a CDN that allows to enhance your website performance, speed and latency with the help of their distributed network across the globe!

Cloudflare offers a premium feature called as Railgun which helps improving the website load times, especially for dynamic websites such as WordPress devloped websites, Drupal, Joomla etc.

Railgun ensures that the connection between your origin server and the Cloudflare network is as fast as possible. It is a premium plugin from Cloudflare which is available as a paid feature. However, we at WebHostUK, being an exclusive Cloudflare partner, offer Railgun for free for websites hosted on our server.

Below tutorial will explain you how to enable Cloudflare with Railgun on our servers.

  • Once your order is processed and your account is enabled, you will gain cpanel access to your account, where Cloudflare tool is available under “Software” section as visible in below screenshot:

  • Click on Cloudflare and it will then redirect you to Cloudflare setup wizard

  • You can use any of your existing Cloudflare account or create a new one. If you already have an account with Cloudflare, then please make sure that the domain (for which you are intending to add Railgun) is not existing in your Cloudflare account. If it is so, kindly delete it from your portal login.

  • To integrate Cloudflare, you have two options:

i. Partial setup also known as CNAME setup of website with Cloudflare : In this setup, your domain will use our nameservers and the CNAME of “www” prefix of your domain will be resolving to Cloudflare alias domain name.

Pro’s of CNAME Cloudflare setup : DNS zones are configured on our server which means, you do not need to do any manual DNS changes for your domain or its MX records or subdomains. These DNS records are automatically configured in DNS zones on our servers.

Con’s of CNAME Cloudflare setup : Since only “www” prefix is configured with Cloudflare alias hostname, Cloudflare with Railgun for the respective website will only work if domain is accessed with www prefix. If the website is not accessed with www prefix, Railgun will not work. So you will have to force redirect your website to its www prefix using rules in .htaccess

ii. CloudFlare DNS Managed setup or full setup : In Cloudflare DNS managed setup, your domain will use Cloudflare nameservers which means all host records including “A”, “MX”, “NS”, “SPF”, “DKIM” etc are all hosted on Cloudflare servers. Cloudflare will control DNS for your domain and we no longer have any DNS control for your websites or its subdomains.

Pro’s of Cloudflare DNS managed setup: Cloudflare with Railgun will work for domain with or without “www” prefix. This eliminates the need of any such redirect of website from non-www url to www url

Con’s of Cloudflare DNS managed setup: Since Cloudflare will manage your DNS, you will need to manually add MX, SPF or DKIM records in Cloudflare DNS portal. Whenever you create any subdomain, its entry will also need to be manually added in Cloudflare DNS portal.

  • Once you have enabled Cloudflare for your domain using any of “cname or cloudflare dns managed setup” as explained above, you will now need to request for enabling Railgun for your domain. In order to request enabling “Railgun” for your domain, you will need to submit a request at :

Your submitted request will raise a support ticket under your account, and our 24/7 support team will then enable Railgun for your requested domain and update you via your support ticket.

How to check if Cloudflare with Railgun is working for your website?

To check if cloudflare with Railgun is working properly for your website, you need to take help of an extension plugin which is available for Google Chrome Browsesr :

Cloudflare if sucessfully enabled for your website and when accessed in Chrome, will show “red” dot as seen in below image

A List of SMTP and IMAP Server

Default Ports:Server:Authentication:Port:
SMTP Server (Outgoing Messages)Non-EncryptedAUTH25 (or 587)
 Secure (TLS)StartTLS587
 Secure (SSL)SSL465
IMAP Server (Incoming Messages)Non-EncryptedAUTH143
 Secure (TLS)StartTLS143
 Secure (SSL)SSL993

Googlemail – GmailServer:Authentication:Port:
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)

Please make sure, that IMAP access is enabled in the account settings.
Login to your account and enable IMAP.
You also need to enable “less secure apps” (third party apps) in the Gmail settings:
See also: How to enable IMAP/POP3/SMTP for Gmail account

SMTP Server (Outgoing Messages)smtp-mail.outlook.comStartTLS587
IMAP Server (Incoming Messages)imap-mail.outlook.comSSL993
SMTP Server (Outgoing Messages)smtp.office365.comStartTLS587
IMAP Server (Incoming Messages)outlook.office365.comSSL993
 Note: If the above settings are not working for your account, then login into the outlook web app, go to the “Settings” > “Options” > “Account” > “My Account” > “Settings for POP and IMAP Access”.
Yahoo MailServer:Authentication:Port:
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
Yahoo Mail PlusServer:Authentication:Port:
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
Yahoo Mail UKServer:Authentication:Port:
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
Yahoo Mail DeutschlandServer:Authentication:Port:
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
Yahoo Mail AU/NZServer:Authentication:Port:
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
NTL @ntlworld.comServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.ntlworld.comSSL465
IMAP Server (Incoming Messages)imap.ntlworld.comSSL993
BT ConnectServer:Authentication:Port:
SMTP Server (Outgoing Messages) 25
IMAP Server (Incoming Messages) 143
O2 DeutschlandServer:Authentication:Port:
SMTP Server (Outgoing Messages) 25
IMAP Server (Incoming Messages) 143
T-Online DeutschlandServer:Authentication:Port:
SMTP Server (Outgoing Messages)securesmtp.t-online.deStartTLS587
IMAP Server (Incoming Messages)secureimap.t-online.deSSL993
1&1 (1and1)Server:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.1and1.comStartTLS587
IMAP Server (Incoming Messages)imap.1and1.comSSL993
1&1 DeutschlandServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.1und1.deStartTLS587
IMAP Server (Incoming Messages)imap.1und1.deSSL993
SMTP Server (Outgoing Messages) 587
IMAP Server (Incoming Messages) 143
zoho MailServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.zoho.comSSL465
IMAP Server (Incoming Messages)imap.zoho.comSSL993
SMTP Server (Outgoing Messages)smtp.mail.comStartTLS587
IMAP Server (Incoming Messages)imap.mail.comSSL993
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
Net@ddress by USA.NETServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.postoffice.netSSL465
IMAP Server (Incoming Messages)imap.postoffice.netSSL993
+ Add ProviderServer:Authentication:Port:
SMTP Server (Outgoing Messages)Contact us to add your provider  
IMAP Server (Incoming Messages)  

How to order UK reseller hosting with free WHMCS and Private Nameservers

Our tutorial that will help you to start your own web hosting business with our UK reseller hosting plan.

Reseller Hosting Guide to help you order UK reseller web hosting from our website

WebHostUK offers white-labelled reseller hosting with free Private Nameservers, free WHMCS billing system (on selected plans), free ENOM reseller account and much more, with one of the best 24/7 support available via live chat and ticket helpdesk!

How to order reseller hosting with free WHMCS and private nameserves?

Our guide will help you start your own web hosting business in less than 10 minutes.

Reseller Hosting Setup Guide will help you with:
1) Choose and order a domain name for your web hosting business
2) Select your reseller hosting plan with us
3) Setup white-labelled private nameservers to represent your web hosting brand
4) Login to reseller WHM and setup your Web Hosting packages
5) Create your first customer under your reseller account.

If you need any more assistance while ordering our reseller hosting plans, please feel free to visit our website at and initiate a live chat with one of our 24/7 support engineer!

How to configure email in Outlook on Windows 10?

Our tutorial that will help you to configure email in your Outlook email client on a Microsoft Windows 10 machine

Tutorial to configure email in Outlook on Windows 10 computer.

You will first need an active account with us. Please visit to signup with one of our web hosting plans.

You can now login to your client portal at

Go to Services to manage your web hosting product with us. It will allow you to create email account in your cPanel.

As an example if your domain name is (this is just an example for reference purpose, please replace it with your valid domain name) then your email client configuration details will be:

Incoming POP3 Server :
Incoming POP3 Secure port: 995
Incoming POP3 non-ssl port: 110

Incoming IMAP Server :
Incoming IMAP Secure port: 993
Incoming IMAP non-ssl port: 143

Incoming SMTP Server :
Incoming SMTP Secure port: 465
Incoming SMTP non-ssl port: 25 or 587

Enter your full email address as your username and its respective password that you configured in cPanel.

That’s all!! and you should be good to send and receive email from your Outlook on your Windows 10 computer!

For any further help, please do not hesitate to initiate a livechat with our 24/7 support from our website

Fix CPU Overload / Abuse Issues ?

Most common things you need to follow will be:

1. Adding cloudflare for your domains which will protect your domains from Unwanted Traffic/Attack/Bot Access 

2. Add robots.txt to understand Search engines to crawl your sites.There are lot of Crawl bots which will give unwanted traffic to your websites which will also cause Overloading on servers like (EP hits)

So create an robots.txt file under your public_html and place the below code : 

User-Agent: *
Disallow: /User-Agent: Googlebot
Allow: /

If you want to add any other search engines to crawl your site you can add it in the above code 

Follow the Above steps for all your domains which is an recommended thing !

For WordPress Users kindly change the File permission of 2 files under your WordPress root wp-cron.php and xmlrpc.php to Permission 000

You can change it from your cPanel > Filemanager As these 2 files will cause overloading on servers by giving unwanted traffic 

Add Heart Beat Plugin to control the admin-ajax.php Once installed WP Admin > Settings > Heartbeat Control > Disable the heartbeat for All 3 Options and click save

Add loginizer which will protect your sites from WP Login attacks (These attacks on most common your websites will be facing daily) So its best way to change your  WP Admin portal URL (VERY RECOMMENDED)

Keep your WP Core,Plugins,Themes Up to date

Remove any Un-used themes or plugins

Don’t use Jetpack Plugin as it will Eat the Resource

How to order a Domain name and UK web hosting for your website?

You can now order your preferred domain name for your website along with UK web hosting services, to get your website published in just a few minutes.

Below tutorial will guide you to select your domain name and order web hosting services at WebHostUK Limited

To get started, please visit our website at

Select the desired type of hosting such as :

Cloud Hosting: or

WordPress Hosting: or

Reseller Hosting : or

Managed VPS server : or

Managed Dedicated Server: and many more.

Today, we will order a shared hosting plan ..

Lets order Linux Standard Cloud Plan which costs £14.99 per year + VAT

To get started please visit

Click on “Order Now” button below “Linux Standard Cloud” plan

Choose your domain option:

1) To register a new domain, select “Register a new domain” 2) To transfer your existing domain from your old registrar over to us, select option “Transfer your domain from another registrar ” 3) To keep your domain with your old registrar and use our nameservers, select “I will use my existing domain and update my nameservers “.

Let’s choose to register a new domain. So select option 1 and enter your desired domain name. You can also select your desired TLD (such as or .com etc) from the dropdown menu. Click “Check” and the wizard will search for domain availability. If it is available, it will show a “Congratulations” message..

Click on “Continue” Select your preferred billing term for web hosting, such as Annual, Biennial or Triennial. You can also choose from several addons that you can select along with web hosting. Click on “Continue” to proceed to next step.

You will be asked to configure your domain details. Enter your valid details and click on “Continue”

This is the final screen which says “Review & Checkout”. Here you can see the web hosting product billing duration that you selected earlier. Below you will see your domain name. By default it will be registered for 1 year. However, you can increase your domain registration to longer duration such as to 2 / 3 years.

Click on “Checkout” Enter your valid details such as Name, Address, and select mode of payment to finalize your order.

Voila … Thats it..!! Your order will now get processed on successful completion of our automated fraud check system. You will then receive all login details for your order which will help you to login to your client portal and cPanel. If at any stage you need any help, you are most welcome to visit our website at and initiate a live chat with our 24/7 live chat support person!

MySql offline error in cPanel

We have recently noticed, Mysql error poping up in cPanel when trying to access “Mysql Databases” tool.

The error mentions about “The MySQL server is currently offline” and also about mysql privileges warning such as “Error encountered while fetching data: There is no such grant defined for user ‘xxxx’ on host ‘localhost’ DBDISKUSED yyyyy 1909382 DISKUSED 1909382 DB zzzzzz DBUSER USER xxxxxx

We are aware about the error which is due to changes in grants in MariaDB 10.3.23. cPanel team is working on the above error and they also have updates posted at:


Please note that while the interface indicates it is down it is only the interface the server is still running.

We do not have any ETA as this is a bug with cPanel and as per their update, they are working actively to resolve the error. We will post more updates when we have one.

Setup WordPress Security Plugin Wordfence

How to Install and setup the Wordfence Security plugin in WordPress.

First thing you need to do is install and activate the Wordfence Security plugin. For more details, see our step by step guide on how to install a WordPress plugin.

Wordfence Setup – WebhostUK

Setting up the Wordfence Security plugin is very simple, but there are a few areas you really wanna make sure are running, like the Firewall.

Click on Wordfence on the left-hand admin panel and select the Dashboard option. This will pull up the main settings page of the plugin. All of the information you need to see is on this page including the last scan, malware blocked, IP addresses blocked, etc.

Wordfence Setup – WebhostUK

The most important part of this security plugin is the Firewall. It will prevent most malicious activity on your website. This is a PHP based application level firewall.

The Wordfence firewall offers two levels of protection. The basic level which is enabled by default allows the Wordfence firewall to run as a WordPress plugin.

This means, that the firewall will load with rest of your WordPress plugins. This can protect you from several threats, but it will miss out on threats that are designed to trigger before WordPress themes and plugins are loaded.

The second level of protection is called extended protection. It allows Wordfence to run before WordPress core, plugins, and themes. This offers a much better protection against more advanced security threats. Click on the Firewall option to access its settings page.

Wordfence Setup – WebhostUK

Click on the Optimize the Wordfence Firewall button. It will run a test to determine the best setting to use. You may pick your own setting, but I would recommend following Wordfence’s recommendation.

Wordfence Setup – WebhostUK

You may pick your own setting, but I would recommend following Wordfence’s recommendation. Click on the Continue button once you have made your selection.

Click on the Download .htaccess button. This will allow Wordfence to run before your core WordPress files. This adds an extra layer of protection because a firewall cannot protect these files making them vulnerable to hackers. Click on the Continue button once you have the file downloaded.

Wordfence Setup – WebhostUK

You will also notice a Learning Mode button. When you first install Wordfence, it attempts to learn how you and your users interact with the website to make sure that it doesn’t block legitimate visitors. After a week it will automatically switch to Enabled and Protecting mode.

Wordfence Setup – WebhostUK

To scan your website at any time, click on the Scan option.

Wordfence Setup – WebhostUK

Click on the Start a Wordfence Scan button. The free version comes with a default automatic 24-hour scan. If you upgrade to the premium version you can set your own schedule and much more. Once the scan is complete you will see a full list of problems it has found.

Wordfence Setup – WebhostUK

The scan will look for changes in file sizes in the official WordPress core and plugin files.

It will also look inside the files to check for suspicious code, backdoors, malicious URLs, and known patterns of infections.

Typically these scans need a lot of server resources to run. Wordfence does an excellent job of running the scans as efficiently as possible. The time it takes to complete a scan will depend on how much data you have, and the server resources available.

You will be able to see the progress of the scan in the yellow boxes on the scan page. Most of this information will be technical. However, you don’t need to worry about the technical stuff.

Once the scan is finished, Wordfence will show you the results.

It will notify you if it found any suspicious code, infections, malware, or corrupted files on your website. It will also recommend actions you can take to fix those issues.

There are many other sections to be aware of. You can view the live traffic feed by clicking on the Live Traffic option. Wordfence Live Traffic shows you what is happening on your site in real-time, including user logins, hack attempts, and requests that were blocked by the Wordfence Firewall. You can choose to log security-related traffic only or all traffic.

Traffic is logged directly on the server, which means it includes visits that don’t execute JavaScript. Google and other JavaScript-based analytics packages typically only show visits from browsers that are operated by a human, while Live Traffic can show visits from crawlers like Google and Bing.

Here you can see the list of IPs requesting different pages on your website.

Wordfence Setup – WebhostUK

This will show you how well Wordfence is defending your website. The Blocking option will allow you to see who is being blocked and allow you to manually enter an IP address to be blocked.

If you have the premium version you can also block entire countries from accessing your website. Explore these sections to see everything they offer.

Wordfence Setup – WebhostUK

Click on the Options option. This will allow you to tweak the Advanced settings that can be found by scrolling down the page.

These settings are all up to you, but should all be considered when setting this plugin up.

Wordfence Setup – WebhostUK

Congratulations, you have successfully installed and set up the Wordfence Security plugin. You can change your settings and scan your website at any time. Remember there are many features that are exclusive to the premium version of Wordfence and you can upgrade at any time, but the free version will be able to guard your website without any issues.