Categories
cPanel Blog

How to Use Remote MySQL in cPanel

Having remote MySQL access can be advantageous for a variety of reasons. Remote hosts (different servers) can access your mySQL database using this function. For example, if you want to make the database available to a third party, such as a shopping cart application.

Find Remote MySQL Feature

Under the Databases section, look for and open the Remote MySQL® tool.

Allowing Remote Server Access to Your Databases

In the Host area, type the hostname or IP address. You can use your public IP address, to access the database from localhost. Alternatively, type a fully eligible domain name, such as www.jkucart.com, and then press Add Host.

Deleting Remote Server Access.

You can do the following to revoke previously granted access:

In the Manage Access Hosts list, find the hostname you want to drop and press Delete.

A confirmation window will appear, and all you have to do now is press Remove Access Host.

That’s what there is to it. Remote access to your MySQL databases can be enabled and disabled with ease. Please don’t grant permission to an unauthorised individual for security purposes.

Categories
cPanel Blog

How to Create MySQL Database in cPanel

To store your data, each website needs a location. Here, we will build a database and allow a user to access it for your domain.

Accessing the MySQL Databases

Use the MySQL Databases tool after logging in.

Creating New MySQL Database

You’ll be taken to a window called MySQL Databases. To make a database, type the name in the appropriate field (without spaces) and press Create Database. Select Go Back when you’re done.

Creating and Adding New MySQL User

The Add New User form is located at the bottom of the page. When filling out the form, leave no gaps between the username and the password. Enter your password twice.

You can also use the Password Generator to come up with a more secure password. If you did, I have copied this password in a safe place and then Use Password.

When you’re done, press Create User.

After clicking Go Back, you can fill out the Add User To Database form. Select the user and the database to which the user will be allocated from the drop-down menu.

You’ll be taken to the Manage User Privileges window after clicking Add.

Providing Privileges to the New User

All that remains is to grant the user privileges in this phase. You can check ALL PRIVILEGES and press the Make Changes button if you’re creating an admin.

That’s it; you’ve successfully built a database, a user, and the required privileges to access the website’s database. Keep in mind that this tutorial only created an empty database, so you’ll have to manually generate or import all of the tables and entries.

Categories
cPanel Blog

How to Edit DNS Zone in cPanel

cPanel provides the Simple DNS Zone Editor and the Advanced DNSZone Editor two different types of Zone Editor. Let’s discuss the first option.

Simple DNS Zone Editor

You will be able to perform four different actions with a simple interface once you open the tool.

A Record
You may add an A record to your domain name by the first action. This can be used to map a hosting domain IP address. In addition, by inserting multiple A records for the same domain, you can also do this to provide domain Redundance.

Click on the button to add one and complete all of the fields necessary. You may enter the record hostname in Name. The IPv4 adress to which you want to point can be entered in the address. Click Add a Record when completed.

CNAME Record
A canonical name may be used to map an alias name to a true domain name, or simply a CNAME. This can be used to map a subdomain from the main domain name, such as www or mail, on its content.

Click the record of CNAME. Enter the record hostname in the Name. And enter the subdomain name you would like to map in CNAME.

MX Record
To establish the location of the email delivery, email servers will use the Mail Exchange (MX) Record. For MX Record and A Record you can have the same value as normal hand-in-hand.

Click the button MX Record to select more. The higher the value the higher, the better. You may use the same value for a corresponding A Record for Destination.

Manage
Click it in the panel if you are looking for an Advanced DNS Zone Editor. It also lists the various DNS records inside your domain.

Advanced DNS Zone Editor

You can customise and edit a TTL for each of your records with the advanced editor. This is very useful, particularly if you want to edit an inactive domain record. You may also create other types of records.

AAAA Record — IPv6 Address
Certification Authority Authorization (CAA) Record — allows a certain authority to issue certificates for the domain
Domain-based Message Authentication, Reporting, and Conformance (DMARC) Record — added to improve safety from fraudulent or suspicious emails
TXT Record — used to hold text information.

Categories
cPanel Blog

How to Park a Domain in cPanel

It is a perfect way to “cover” your brand to have another type of domain. But you’d probably purchase multiple domain names if you want your brand to be online.

You can, for example, also buy other common TLDs, such as .org, .net, and country code options when you launch your brand under yourdomain.com (.us for webmasters in the United States, or .jp for Japan).

So any time visitors go to yourdomain.org, instead, yourdomain.com will be pointed to your main domain. The domain parking method allows you to configure it. To do exactly that, cPanel offers a method called Aliases.

Locate Aliases

Open the Aliases tool under the Domains section from the main dashboard of your cPanel.

Create a Parked Domain

Under the Create a New Alias section, type the domain name you want to add and press Add Domain.

Hostnats-test.in as an alias is added in this example. So you get the same outcome as visiting hostnats-test2.in when visiting that URL.

A domain from a proper registrar needs to be included. If not, an error message will be sent.

Manage Redirection

The domain will be shown in the aliases list once you have added it. Tap Redirect Management.

Alias Redirection

In the form, enter the main domain of which you wish the alias to point to and press Save.

If you have successfully added the redirection, the move takes up to 24 hours due to the global spread of DNS.

Categories
cPanel Blog

How to Create a Subdomain in cPanel

Subdomains are domain extensions. They function independently of the main domain and can therefore be used to host additional websites. A subdomain is formatted as subdomain.domain.com.

Let’s say we own the domain mywebsite.com and want to use it to host a forum and a blog for the main site. On forum.mywebsite.com and blog.mywebsite.com, we were able to find them. Mywebsite.com/forum and mywebsite.com/blog can also be used to access these subdomains.

To create a subdomain, go to the cPanel subdomains section.

  • Subdomain – subdomain’s name is represented by field. Only the subdomain extension must be defined in this section.
  • Domain – The domain in which the subdomain will be generated is defined in this area.
  • Document Root – It is a subdomain’s root directory. By design, this folder is generated in public html.

This message will appear on your screen after you press Create.

If any errors or problems arise during this process, you should contact your hosting provider for assistance.

Uploading files to the Document Root of subdomain

Upload all files and scripts to the Document Root directory specified. The directory is built automatically in public html and can be easily accessed via cPanel’s File Manager section. If you use an Addon Domain to construct a subdomain, the subdomain’s Document Root will be generated in the addon domain’s root directory, for example: public html/addon domain root/subdomain root.

Deleting a subdomain

It is always possible to delete a subdomain if it is no longer necessary or if the name was entered incorrectly. The Remove button in the cPanel->Subdomains section can be used to delete a subdomain.

In summary, subdomains are a quick, cheap and efficient way to create additional sites since additional domain names are not required. They can also be used to create separate sections of your main website, such as a forum, blog, or store.

Categories
cPanel Blog

How to Create an Add-On Domain in cPanel

Additional domains stored as a subdomain of your main site are known as add-on domains. Using the Addon Domains feature in cPanel, you can easily build and manage multiple domains with a single account. Let’s get this discussion started.

Accessing Addon Domains Tool

Check for and open Addon Domains from your main dashboard.

Creating an Addon Domain

After you’ve opened the tool, you’ll need to complete the form. Here’s how each area is explained:

  • New Domain Name — You just need to type in the domain name you want to add. We’re using test-hostnats.in in this situation.
  • Subdomain — The subdomain name will be added automatically by cPanel. If you’re just going to add one domain, leave it alone. Otherwise, you’ll need to change it if you want to add two domains with the same name but separate TLDs, such as samedomainname.com and samedomainname.net.
  • Document Root — It will also fill itself automatically. This is the location of the content for your addon domain.
  • Create an FTP Account (Optional) — You may use this method to build a new FTP account for the new addon domain. You don’t need to build a domain if you’re going to handle it yourself. You should, however, check the Create an FTP account associated with this Addon Domain box if you want to set up the addon domain for someone else. They will only be able to access the files of that particular addon domain if they have their own account.

Once you’ve filled that, click the Add Domain button.

Now that the addon domain has been successfully created, you can begin uploading the website’s files to the newly created subfolder in your cPanel account’s File Manager.

Manage the Addon Domains

The domain should appear in the Modify Addon Domain list once it’s been added. The following is the section’s description:

  • Addon Domains — Here you can see all of the domains you’ve added.
  • Document Root — that particular domain’s folder path The link will take you to the File Manager when you click it.
  • Subdomain — a name produced automatically in the form
  • Redirects to — You can use the same function as Aliases to redirect the domain to another location. It says not diverted because we aren’t doing that. If you want to do so, simply click the Manage Redirection button, which will open a new window where you can set the redirection course.
  • Actions — a way to take the addon domain off the list

You’ve now learned how to use your cPanel account to build and manage addon domains. Using the same username, you can upload files and control the backend for several domains.

Categories
cPanel Blog

How to Set up Two-Factor Authentication in cPanel

Since the data in your cPanel account is so significant, enabling two-factor authentication (2FA) is a good idea.

In a nutshell, it’s one way to make your account more safe. You can create a time-based one-time password (TOTP) with software, which will give you an individual code that you must enter before gaining access to your account.

Enabling Two-Factor Authentication in cPanel

Open the Two-Factor Authentication tool after logging into your cPanel account. Then, on the Set Up Two-Factor Authentication page, press the Set Up Two-Factor Authentication button.

Now go to your Authy app and open it. You can either scan the QR code or manually insert the Key from there.

You must then enter the six-digit token that appears on your Authy app after it has been scanned. Then select Configure Two-Factor Authentication from the drop-down menu.

Getting back to cPanel

When you press Go Back, you’ll be taken back to the login screen. The six-digit token from your Authy app must be entered. This is something you’ll have to do any time you try to log in to cPanel.

You’ve also successfully added an extra protection layer to your account, making you much safer even though an unauthorized individual has your password.

Categories
cPanel Blog

How to Check Disk Space Usage in cPanel

The total amount of data in your account, including website files, MySQL databases, and e-mail addresses, is referred to as your disk space use.

When you hit 80 percent, 90 percent, 98 percent, or 100 percent disk use, cPanel will automatically give you disk space warnings to your e-mail address. In the Preferences section of cPanel, you can change your contact e-mail address.

Disk Space Use in a Nutshell

When you log into your cPanel, you’ll see a brief rundown of your disk space use on the right hand side.

Statistic on Disk Space Use

Click the Disk Usage button in the Files section of your cPanel to see detailed information about your disk space usage.

Scroll down the list, then click the > sign to the left of each folder to enlarge it. This will inform you exactly how much disk space you have left.

Click on the desired folder to open File Manager in your browser and delete any unwanted files.

Congratulations on figuring out how to verify your cPanel Disk Space Usage. It’s helpful when you need to figure out what’s causing you to exceed your disk space quota.

Categories
cPanel Blog

How to Check Bandwidth in cPanel

The total amount of incoming and outgoing traffic or data transmitted on your hosting account is referred to as bandwidth. Many factors influence use, including visitors, email contact, and the inclusion of even an FTP communication.

You should look at bandwidth use since it normally applies to the hosting package that you purchased. When you get close to the cap, cPanel will give you an automatic email notification.

Quick Overview of Bandwidth Use

When you first log in, the bandwidth use overview appears in the right-hand panel under the statistics column.

Detailed Bandwidth Statistics in cPanel

The detailed statistics can be found by clicking the Bandwidth connection from the previous section. You can also use the search function to look for bandwidth by name.

When you choose one of the two options, a new window will open that displays your usage on a regular, weekly, and monthly basis, as well as the total amount of your usage.

Take a look at the regular bandwidth use on our development site as an example.

As you can see, cPanel now tracks traffic from the following sources:

  • HTTP traffic – The data sent and received over the HTTP protocol is referred to as HTTP traffic.
  • FTP Traffic – keeps track of the file transfer protocol you use to access and exchange data between your device and the server.
  • IMAP/POP3/SMTP Traffic – this refers to email traffic between your server and a computer/mail client.

That’s what there is to it when it comes to bandwidth consumption. Understanding what is causing you to exceed your quota cap and acting on it is extremely beneficial.

Categories
cPanel Blog

How to Use the File Manager in cPanel

The File Manager is the tool you’ll need to handle your cPanel’s basic files. You can use it to create files and directories, assign permissions, and so on, in addition to uploading and removing files.

It essentially performs the same functions as an FTP client, though it is not as efficient.

Step 1: How to Locate the File Manager

You should be able to locate the File Manager once you’ve signed into your cPanel account. It can be found in the Files folder. You can also do a name search.

When you first launch the tool, you’ll be taken to a new window with navigation and management options, as well as a directory of your website’s folders and files.

We’ll just deal with the public html folder from now on. The device requires all of the remaining folders to ensure that the cPanel service is functioning properly.

Step 2: How to Operate the File Manager

First, there’s a window section with a folder tree on the left and the contents of a folder on the right. By selecting the appropriate folder, you can navigate to it. Clicking the public html folder, for example, will show its contents –.well-known, cgi-bin, robots.txt, and so on.

You can also use the folder tree search function to navigate to a particular folder by typing the full name path and pressing Go.

There are a number of options for navigation:

  • Home — when you select it, the Home folder and its contents appear.
  • Up One Level — takes you one level higher than where you are now. For example, if you click this while in the cgi-bin folder, it will take you to the public html folder, which is a higher level than the cgi-bin folder.
  • Back/Forward — functions similarly to your web browser’s back/forward navigation.
  • Reload — To see the updates, refresh the page.
  • Select/Unselect All — To select or unselect files or folders
  • View Trash — Displays the Trash folder, which contains all deleted files
  • Empty Trash — To empty the Trash folder, This option is only available when you’re in the Trash folder.

Step 3 : Making Use of the File Management Option

After learning how to navigate, the next step is to learn how to use the file management features. A toolbar is available to assist you, but most of the functionality can also be accessed by right-clicking on a particular object.

  • File – This function allows you to build a new file inside a selected folder.
  • Folder – You may use this function to make a new folder.
  • Copy – You have this option to copy the selected file to a specific location.
  • Move – This feature functions in the same way as Copy. The only difference is that the file will no longer be located in its original position.
  • Upload – You can upload a file to your hosting account from this page. You cannot, however, upload folders. You may use an FTP client to upload a folder or a larger file. You have two choices for uploading the file: drag and drop or manually pick the file from your screen. When you’re done, click the Go Back.
  • Download – This feature will download the files you want to your screen.
  • Delete – The selected file is moved to the Trash folder with this choice. Check the Skip the trash and permanently delete the files box if you want to delete the file permanently.
  • Restore – Only when you’re in the Trash folder can you use this feature. You can restore a deleted file to its original folder.
  • Rename/Edit/HTML Editor – To edit your files, you’ll need these features. They function similarly to any text editor programme and can be very useful for on-the-go editing. Despite having a WYSIWYG gui, it isn’t as effective as other HTML editors.
  • Permissions – To edit your files, you’ll need these features. They function similarly to any text editor programme and can be very useful for on-the-go editing. Despite having a WYSIWYG gui, it isn’t as effective as other HTML editors.
  • View – This can be used to view a file, such as an image or the contents of the index.php file.
  • Extract/Compress – Compress allows you to store files in Zip, Gzip, or Bzip2 formats. Extract, on the other hand, will extract an archive.
  • Settings – You can customise your preferences using this function. You can set the default folder to open anytime you use the File Manager, for example. You can also switch on the Show Hidden Files option (dotfiles).

That’s pretty much all there is to know about cPanel’s File Manager navigation and management functionality.