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.