Shell access to your server using SSH (PuTTY for Windows)
All Krystal plans apart from Amethyst include SSH access.
If you are a reseller we have a separate guide on enabling SSH for your account and then creating WHM packages to enable it for your clients.
PuTTY is the de facto SSH client for Windows. Partly because it's free, but mostly because it just works so well!
Download and install PuTTY
If this isFew readersHow to use public/private keys for SSH and SFTP (Windows)
This article assumes you have already installed the PuTTY suite of applications.
Public/private key authentication, as the name suggests, uses two special cryptographic text files (called keys) to authenticate your login. The private key remains on your computer and should be kept safe from unauthorised access. The public key can be freely installed on remote systems. It doesn't matter if your public key gets stolenFew readersJetbackup - Restore or download an email account backup
This guide walks you through restoring or downloading a backup file for an email account.
We have a separate guide that focuses on full account and file restoration using JetBackup and another for restoring a database.
JetBackup is accessed from within your account's cPanel, in the Files section.
Restore an email accountFew readersHow do I enable and disable SSH (Secure SHell) access?
We do allow limited command-line shell access via a caged environment. The SSH port for our servers is 722.
Cloud, Premium & Business accounts
For cloud or business users you can enable SSH via your Krystal Client Area by logging in, then selecting the My Services options.
(https://storage.crisp.chaFew readersHow do I get a free SSL certificate for my website? (AutoSSL)
An SSL (Secure Socket Layer) certificate is required for the conversation between your website and a visitors browser to be secured. It's now best practise to load all sites over https:// rather than http:// - your visitors will see a secure padlock in their web browser and can be sure that data they enter into your contact form or purchases from your online store are secure.
Krystal offers free SSL certificates from AutoSSL. You can issue these yourself from within your hosting cPanel.
YoFew readersJetBackup - Restoring your Home Directory from a backup
We use JetBackup for our internal system backups and we share these backups with you to enable restoration of files, databases, CRON jobs, DNS Zones, Email, SSL Certificates and your full account. You can also download copies of these backup files.
If you'd like to take ad-hoc backups (which you can also restore from) we have a separate guide all about cPanel Backup and Restore.
We have a separate guide on using JetBackup to restore emaiFew readersUsing cPanel Directory Privacy
There may be occasions when you want to limit access to either the whole or part of your web site/hosting.
For example, if you are setting up a new static site and want to restrict access until the site is ready to go live.
Click the Directory PrivFew readersJetBackup - Restore or download a database backup
This guide walks you through restoring or downloading a backup file of a database.
We have a separate guide that focuses on full account and file restoration using JetBackup and another on restoring an email account.
JetBackup is accessed from within your account's cPanel, in the Files section or directly through the JetBackup section.
Restore a databaseFew readersShell access to your server using SSH (MacOS Terminal)
As Mac OS has a built-in terminal client you can simply load this up and enter the following command ensuring you enter the cPanel username and server hostname that match your own account e.g.
ssh -p 722 username@carbon.cloudhosting.co.uk
This will then prompt for a password which will be your cPanel password - enter this to complete the login process.
SSH Keys are recommended if you want to restrict SSH access to users with a key rather than just the SSH password.
We have a sFew readersJetBackup - Restoring a full account backup
We use JetBackup for our internal system backups and we share these backups with you to enable restoration of files, databases, CRON jobs, DNS Zones, Email, SSL Certificates and your full account. You can also download copies of these backup files.
If you'd like to take ad-hoc backups (which you can also restore from) we have a separate guide all about cPanel Backup and Restore.
We have a separate guide on using JetBackup to restore emaiFew readersJetbackup - Restore or download from your backups
We use JetBackup for our internal system backups and we share these backups with you to enable restoration of files, databases, CRON jobs, DNS Zones, Email, SSL Certificates and your full account. You can also download copies of these backup files.
If you'd like to take ad-hoc backups (which you can also restore from) we have a separate guide all about cPanel Backup and Restore.
We have a separate guide on using JetBackup to restore emaiFew readersMy database isn’t showing in PHPMyAdmin
If you've just created a database via the MySQL Databases section of cPanel, you may occasionally find it doesn't display immediately within PHPMyAdmin (stopping you from importing data to it). Don't panic if this happens! This can be caused by a known glitch within cPanel where PHPMyAdmin becomes de-synchronised with cPanel.
The easiest way to fix this is by simply changing your cPanel password.
Once thisFew readersJetBackup - How to view queued jobs and email notifications
This guide walks you through accessing the JetBackup Job Queue and setting up Email Notifications.
Viewing the Job Queue
Log into cPanel.
Under the Files section, click on JetBackup to go to the JetBackup Dashboard.
(https://storage.crisp.chat/users/helpdesk/website/f1Few readersImporting a website into Softaculous
Softaculous is able to import local (same server and hosting package) or remote (different server or hosting package) application installations.
Softaculous is also able to Clone sites and create Staging sites (where any changes can be pushed back to the original site).Few readersHow to export a database using phpMyAdmin
This guide explains how to export a cPanel database using phpMyAdmin. This can be useful should you just need to take a backup, or wish to export your database for you to later import elsewhere.
This guide assumes you're logged in to the cPanel account containing the database to export.
Open phpMyAdmin by clicking the icon in the DATABASES section.
(https://storage.crisp.chat/users/helpdesk/websiteFew readersHow to change your primary cPanel hosting account domain
All cPanel accounts have a primary domain name associated with them. This main domain can only be changed by raising a Support Request.
When you submit your support request you'll need to specify
the cPanel account username
the existing domain name
the new domain name you wish to use.
Remember to make sure the new domain's nameseFew readersChanging your PHP Version, PHP Extensions, PHP Functions and PHP Options
PHP is a programming language and forms the basis of many modern content management systems like WordPress, Joomla and Drupal.
This article describes how to change a cPanel account's PHP version, add or remove PHP modules, change PHP options and how to enable functions. All actions are completed within cPanel for the domain you wish to change.Few readersUsing cPanel File Manager
cPanel comes with a full-featured file manager and this article describes it's basic functionality, including how to access hidden (dotfiles) and setting file and directory permissions.
File Manager
You can find it at cPanel Files File Manager
You can use file manager for quick tasks; like uploading a single file or .zip archive (and then extracting it e.g. for a WordPress plugin) or setting file and directory permissions. For larger tasks, for example, uploading a full website wFew readersSetting up CRON jobs
Cron is a task scheduler that is built into the Linux operating system. It is very flexible and allows you to schedule all kind of automated tasks. The cPanel Cron jobs icon in the Advanced section of cPanel provides a simple graphical interface to use this great feature.Few readersHow to connect to a MySQL database using PHP
The hostname to use when connecting to one of your cPanel MySQL databases from a web script running within the same cPanel account is localhost.
As a quick guide, you can use the following PHP code to make a connection.Few readersMeasuring and reducing disk usage in cPanel
Your digital garden
We've all been there – that heart-stopping moment when you realise your website or server is running low on storage space.
Thankfully, cPanel allows you to monitor your usage statistics and can quickly show you where your usage comes from, andFew readersHow to import a database using phpMyAdmin
This article will show you how you can import a database from a file on your local computer to your Krystal cPanel account. This article assumes that you are already successfully logged into cPanel.
We have a separate article on importing large databases which may time-out or error when importing through phpMyAdmin.
Before you can import a database dump file from your computer, a destination database must already exist withiFew readersHow to create a MySQL database and users
This guide explains how to create MySQL databases in cPanel, create database users with permissions and assign them to databases.
You'll need to be logged in to cPanel to complete these steps.
Manage Databases (Create, Check, Repair, Rename, Delete) & Users
Within the Databases section of cPanel click MySQL Databases.
At the top of the MySQL DatabaseFew readersHow do I enable Redis on my Premium PCI-DSS compliant hosting account?
What is Redis?
Redis (Remote Dictionary Server) is an open source (BSD licensed), in-memory data structure store, used as a database, cache and message broker.
It supports data structures such as strings, hashes, lists, sets, range queries, bitmaps, hyper loglogs and geospatial indexes with radius queries.
In its simplest form, Redis is a caching system that can be combined with MySQL or MariaDB to optimize the application level speed.
Why should I use Redis?
Redis runFew readersFile Transfer Protocol (SFTP & FTP/S) - how to add FTP accounts
File Transfer Protocol as the name suggests is a standard way of transferring files between computers. You can use it to transfer files from your computer to your web hosting space.
Krystal servers support SFTP (SSH FTP) and FTP/S (explicit SSL/TLS FTP).
This guide details how to manage additional FTP accounts and the difference between them and the cPanel Default FTP account.
We have separate guides on setting up some common FTP applications including FileZilla (/web-hosting/using-file-zillFew readersAll about cPanel backup & restore
We have two backup solutions in place on our hosting servers.
We use Jetbackup for our internal system backups and we share these backups with you to enable restoration of files, databases, CRON jobs, DNS Zones, Email, SSL Certificates and your full account. Whilst you can't take ad-hoc backups using Jetbackup, we have a series of guides covering Restoring your data using JetBackup( Link opens in a new window)
We also provide cPanel backups - and this funcFew readersHow to use public/private keys for SSH and SFTP (MacOS)
MacOS is derived from Unix style operating systems, so understandably, the tools to manage SSH connections are already built in.
Public/private key authentication, as the name suggests, uses two special cryptographic files (called keys) to authenticate your login. The private key remains on your computer and should be kept safe from unauthorised access. The public key can be freely installed on remote systems. It doesn't matter if your public key gets stolen or lost. Because only you have the pFew readersStaging a website with Softaculous
It's rarely (never) a good idea to make significant updates to a live site - minor content tweaks maybe - but updates to plugins, themes or core files should all be tested on a staging version of your site - to ensure nothing breaks - before being pushed to live.
Softaculous Apps Installer includes the ability to create a staging copy of your site - and then track file & database changes - so these can be pushed back to the live site once you're sure everything is working as you expect.Few readersHow to configure cPanel contact information
Each cPanel account has its own contact email settings. This is so that the administrator of the cPanel account can receive warnings and alerts from the server regarding things like disk space usage, and security alerts.
This email address is initially set to your main Krystal client login email address (at the time the cPanel account was created).Few readersHow to view AWStats without logging into cPanel
AWStats is a log analyser that can be accessed via your hosting account's cPanel to view your hosting access logs graphically.
It is, however, also possible to have your stats visible on a web page, so they can be viewed without logging in to cPanel.Few readersHow to connect to a MySQL database from an external host
The MySQL server runs on each local hosting server on TCP Port 3306 (the standard port for MySQL). When your web scripts connect to MySQL they can do so usinglocalhostas the server name. However, you can also connect to your databases from an external host, such as your home PC, office, or another web server.
Preparing to connect
Before getting started you will need the IP address of the host you are connecting from, this can be done by browsing to https://viewmyip.co.uk on the device inFew readersWhat happens if I exceed my plans disk space allowance?
We have a separate article on monitoring and managing your disk usage which has some useful tips on how to check what's using the space in your account.
cPanel space usage exceeded
Everything in your account adds towards your total space usage. This includes your website files, databases and email. As a cPanel account approaches its full capacity (usually 80%, 90% and 98%), the server will send automatic warning emails to the contactFew readersInstalling an SSL on your shared cPanel account.
Krystal hosting do provide Let's Encrypt SSLs on all our shared plans for free. If you need to purchase an SSL from a SSL provider (Krystal do not sell certificates) then you will need to generate a CSR to request a certificate for your site.
Generating a CSR
Log into your cPanel account.
Once Logged in, scroll down to the 'Security' section and click 'SSL/TLS'.
Click theFew readersHow to import a large database into MySQL
This article will show you how you can import MySQL databases that are too large to upload reliably using the phpMyAdmin tool included in cPanel. Uploading a large database via phpMyAdmin can take a long time, and a dropped connection or other issues can make it very frustrating. In cases like this, it is better to import the database manually using an SSH (Secure Shell) session.
You'll need to connect to your server using SSH to complete this process. We have separate guides on connecting to yFew readersInstalling Magento using Softaculous
Magento can be very resource-intensive and is therefore only available and supported through Softaculous on our Business Hosting (link opens in a new window) packages.
Before you start the Magento installation please ensure you've applied a LetsEncrypt SSL certificate (or installed your own EV SSL if you have one) - so that your site will be served over HTTPS.
Using the lFew readersHow to connect to MySQL using MySQL WorkBench
This is a brief guide to connecting to MySQL using an SSH Tunnel within the MySQL WorkBench application provided by the MySQL website - external link opens in a new window.
Create a new connection within MySQL WordBench using the following details:
Connection Name: Enter a name to identify this connection.
Connection MethoFew readersHow to backup a databases from the command line
This article will show you how to manually create a backup of your databases via. SSH and through a cron job. This article assumes you are already logged in to cPanel, and that you already have your Windows or Mac computer setup for SSH access, and that you understand directories and files reasonably well.
Creating a one-off backup via SSH
Using PuTTY or another SSH client, log into your SSH account. Once logged in, just enter the following command, changing mysqluser and mysqldatabaFew readersHow to block bad spiders from wasting bandwidth
Search engines use technology known as spiders to search the web. A spider is an agent (also called a bot - short for robot) that will connect to your website and download a copy of all of your pages (or try to) in order to populate the search engine it is working for. However, spiders are supposed to obey certain rules (defined in your robots.txt file), and they are definitely not supposed to thrash your website to the point that is causes a denial of service, or uses up all of your bandwidthFew readersHow to install WordPress using Softaculous
Before you start the WordPress installation please ensure you've applied a LetsEncrypt SSL certificate (or installed your own EV SSL if you have one) - so that your site will be served over HTTPS.
From within your cPanel, scroll down to the SOFTWARE section and click on Softaculous Apps Installer.
(https://storage.crisp.chat/users/helpdesk/website/cf6736d03277e000/9Few readersCloning a website with Softaculous
Cloning in Softaculous allows you to quickly make copies of your applications. It can also be used to alter those copies, for example:
To move a site from a sub-directory/folder (/domains/the-difference-between-a-sub-domain-and-a-sub-directory-oFew readersHow to connect to a MySQL database using an SSH Tunnel
Connections to MySQL servers over port 3306 are not encrypted, and so this presents a real security risk. Indeed, some credit card processors will not provide user accounts to websites that are hosted on servers that allow unencrypted connections on port 3306.
This article will describe the steps required in order to connect securely to your web hosting account's MySQL server using an SSH Tunnel. This is an advanced topic and assumes that you have some experience of connecting remotely to MySQLFew readers