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/Mysql.pm line 956, <STDIN> line 1.
Cpanel::Mysql::__ANON__(__CPANEL_HIDDEN__...) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm 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:
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
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 Cloudflare.com 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 : https://www.webhostuk.co.uk/railgun-request.php
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?
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: https://support.google.com/accounts/answer/6010255?hl=en See also: How to enable IMAP/POP3/SMTP for Gmail account
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
SMTP Server (Outgoing Messages)
IMAP Server (Incoming Messages)
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”.
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!
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 https://www.webhostuk.co.uk and initiate a live chat with one of our 24/7 support engineer!
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 :
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
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 https://www.webhostuk.co.uk
Select the desired type of hosting such as :
Cloud Hosting: https://www.webhostuk.co.uk/web-hosting.html or
WordPress Hosting: https://www.webhostuk.co.uk/wordpress-hosting.html or
Reseller Hosting : https://www.webhostuk.co.uk/reseller-hosting.html or
Managed VPS server : https://www.webhostuk.co.uk/vps-hosting.html or
Managed Dedicated Server: https://www.webhostuk.co.uk/dedicated-hosting.html 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 https://www.webhostuk.co.uk/web-hosting.html
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 .co.uk 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 https://www.webhostuk.co.uk and initiate a live chat with our 24/7 live chat support person!
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:
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.
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.
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.
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.
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.
To scan your website at any time, click on the Scan option.
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.
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.
Here you can see the list of IPs requesting different pages on your website.
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.
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.
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.