What Is phpMyAdmin In cPanel?

Name: SeekaHost
Brand: SeekaHost
Rating: 4.9 (387 reviews)

What is phpMyAdmin?

phpMyAdmin is a third-party tool in cPanel which is generally used to manage tables and data inside a database. It acts as an interface to manage MySQL databases. phpMyAdmin is a raw view of the data, tables, and fields which are stored in MySQL database accessible through it.

What is phpMyAdmin good for?

It is a user-friendly program for performing maintenance operations on tables, backing up information and also can edit things directly in the event that WordPress is not working. Many of the tasks can be performed on the MySQL command line, doing so is not an option for many people.

Features of phpMyAdmin:

It has a user-friendly web interface

Supports most of the MySQL features. Such as

Browse and drop databases, tables, views, fields, and indexes.
Create, crop, drop, rename and alter databases, tables, fields, and indexes
Manage MySQL user accounts and their privileges.

And more on.

How to get and access phpmyadmin?

Most of the hosting companies providing control panels such as cPanel and Plesk has phpMyAdmin preinstalled. It is usually linked to the database page. You can also download phpMyAdmin by yourself and install it from the main phpMyAdmin.

To access it, click on the phpMyAdmin link which is available under the section Databases.

There you can see the dashboard page of the phpMyAdmin.

On the left-hand side, you can see the list of databases by expanding it to see the table in each database. On the right side, it displays the general information of the Database server.

phpMyAdmin allows the user to interact with the database directly. At times, it makes you mess with the database directly. The major thing is, the options such as ‘Undo’ or ‘Undelete’ are not present in your database. So, we suggest you to be cautious when working with the database.

[Tweet “What Is phpMyAdmin in cPanel?”]

If you are a registered user in SeekaHost and have any queries to be clarified or issues to be sorted, you can raise a ticket through client area dashboard or email to [email protected]. For immediate interaction or guidelines, contact our support team available in LiveChat at the right bottom corner of the website.

How to Optimize Website Using cPanel?

The “optimize website” feature in cPanel allows the user to make gzip compressions. Gzip compressions are supported by most of the browsers. For gzip compressions the Apache mod_deflate is very much needed to function and it will be available in most of the Linux servers. It saves the bandwidth which is a big advantage for most of the users and enables the site to load faster. It can compress all types of files.

Enabling gzip compression:

STEP 1: Opening the interface

Open the Optimize website interface by clicking on the link which is under the ‘Software’ section.

STEP 2: Compressing types

In “optimize website“, you can Compress the Content.

In the given options, you can choose any one of the following.

Disable – It is used to disable the gzip compression.

Compress All Content – Used to enable gzip compression for all content in your website.

Compress the specified MIME types – It provides the types of MIME(Multipurpose Internet Mail Extensions) in the text box. MIME are similar to the file types. It has both the file type and file format information separated with a slash.

Example: text/css, image/png, image/jpeg etc.,

STEP 3: Updating the settings

Click on ‘Update Settings’ to update it.

[Tweet “How to Optimize Website Using cPanel?”]

How to Use Website Virus Scanner in cPanel?

A virus scanner is the most important feature in the application side and also even for websites, servers, etc., cPanel with a virus scanner is a huge advantage for the hosting users. This helps the hosting users to safeguard their files, folders, etc., from harmful threats. The user can also scan the different sectors of the home directory by using the antivirus.

Scan Account with Virus Scanner in cPanel

STEP 1: Opening the Virus Scanner

Type ‘Virus Scanner’ in the search box and click on it.

STEP 2: Scan Now

Choose the type of scan from the given options for scanning. Click ‘Scan now’.

Scan Entire Home Directory – This option helps you to scan the entire cPanel. If you choose this option, you don’t need to scan on other options.

Scan Mail – It scans your emails for viruses.

Scan Public FTP Space – It scans the public_ftp folder.

Scan Public Web Space – It scans the public_html folder, where all the end files reside.

STEP 3: Completion of Virus Scan

After scanning, it notifies that the ‘Virus Scan is complete’ and ‘No Viruses found’. If there is a presence of malware, it displays the files which are infected.

STEP 4: Process Cleanup

You can remove the malware by checking the buttons under the option ‘Destroy’ and click on ‘Process Cleanup’. Now, the malware from your cPanel is totally removed.

How to do Password Protection for Directory in cPanel?

We know that there are various features are available in cPanel. In this article, we are going to know a feature called ‘Directory Protection’ in cPanel. This directory protection feature allows the user to protect the directory with a username and password. Below mentioned are the steps to create password protection for the directory in cPanel.

Configure Password for Directory in cPanel:

STEP 1: Directory Privacy

Type ‘Directory Privacy’ in the search box and click on it.

STEP 2: Navigating Through Directories

Open the directory privacy configuration and navigate through the directories in which you want to protect. You can simply click on the ‘icon’ to open the directory folder. Click on the name to select the ‘folder’.

STEP 3: Edit the Directory

Click “Edit” action near the directory which you want to protect to configure the password for the directory.

STEP 4: Password Protection for Directory

click the checkbox ‘Password protect for this directory’ and enter a name for the protected directory. Click ‘Save’

STEP 5: User Creation for Directory

Under ‘Create User’ menu, enter the username and password to create a new user, click ‘Save‘.

STEP 6: Authorized Users

To see the added users, you can see the username under the section “Authorized Users“. You can also create more than one user here.

How To Increase Upload Limit Size (WordPress)? – cPanel

Increase Upload Size Limit for WordPress

You can upload any type of files in your site such as images, video, themes, gifs, etc., These files can be uploaded only when you have enough file upload size limit. If you have less size limit, then you are not able to upload the files in the site. This is a major issue faced by most of the WordPress and other CMS users. This can be easily solved through cPanel of your domain. In this article, you will know how to increase file upload size limit through cPanel MultiPHP Ini Editor.

Errors You Might Face When Because of File Upload Size Limit:

The uploaded file exceeds the upload_max_filesize directive in php.ini
413 Error: Request Entity Too Large, Link you followed has expired
Fatal error: Allowed memory size of 12345 bytes exhausted (tried to allocate 2345 bytes) in /home/your-username/public_html/wp-includes/plugin.php on line 1000
Exceeds the maximum upload size for this site
Unable to create a directory and broken images in the Media Library

Steps in increasing the file upload size limit through cPanel.

STEP 1: Login

STEP 2: MultiPHP INI Editor

Search ‘MultiPHP INI Editor’ and click on it.

STEP 3: Basic Mode

There you can see two types of mode available. Click on ‘Basic Mode’ and choose the location which is domain’s root document to edit their PHP configuration.

STEP 4: Increase post_max_size and upload_max_filesize

By default the PHP directive values will be updated to minimum value required for a website to function the task. If you couldn’t see files (php.ini and user.ini) created in your public_html directory, then just click “apply” to create one to make it execute.

1. If you want to increase the values in upload_max_filesize, just update the value in the setting box.

2. Then in the “post_max_size directive“, enter the value larger than the ‘upload_max_filesize’.

For example, if your upload file size is 100M, then “upload_max_filesize” value should be 100M and “post_max_size” directive has to be “101M”

3. Make sure the PHP memory limit is higher than the post_max_size and upload_max_filesize.

STEP 7: Save Changes

Click on ‘Apply’. The settings will be saved.

Thus, these are the steps involved in increasing file upload size limit through cPanel.

[Tweet “How To Increase Upload Limit Size (WordPress)? – cPanel”]

Step By Step Guide to Create an Addon domain in cPanel

What is Addon domain?

Addon domain is a separate domain hosted under your primary domain. Addon domains have the full functionality as like primary domain.

You can create email addresses, forwarders, and more the same way as a primary domain on the account.

One of the main benefits for creating addon domain is that you can manage multiple domains in a single account.

Content and Files for this addon domain will be stored as a unique folder within the public_html. This domain will be created in the cPanel account.

How to create Addon domain/Subdomain?

Login to your cPanel Account with the access given by your web hosting providers.
In search, enter “Domains” and click “Create a New Domain” as shown below.

Enter the domain name that you want to add as Addon/Subdomain domain in the text box.
Once you have entered the domain name, it will automatically fetch the Subdomain & Document root folder as shown below.

The document root is the directory where the files will be stored. The default directory will be public_html.
If you want an FTP account for your Addon domain, enable the option “Create an FTP account associated with this Addon Domain.”
Enter the username and password for an FTP account and click on Add domain.

Create Subdomain:

If you want to create subdomain for your main domain or any domain without creating the addon domain, you can mention the “subdomain” name in the domain text box. In the Document Root folder text box, you can mention the folder name under which you want to store the files.

To install WordPress for the subdomain, click “WordPress” and then click install under the “softaculous app installer” section. Now choose the domain name from the drop-down.
You can view the WordPress files under the subdomain domain folder inside the public_html directory.

How to modify Addon domain account?

If you want to modify the destination path or subdomain name, uncheck the box here or you can leave as it is.

Modify the details as mentioned in the screenshot below,

To redirect your addon domain, click on Manage Redirection. Enter the link to which you want to redirect your domain and click save.
To install WordPress for the addon domain, under the “softaculous app installer” section, click “WordPress” and then click install.
Now choose the addon domain name from the drop-down as shown below,

You can view the WordPress files under the addon domain folder inside the public_html directory.

Unable to Create Addon Domain/Subdomain:

If you are facing any issues while creating Addon Domain then it should be because of the below-mentioned reasons.

Before adding the domain, main domain nameserver must be updated for the addon domain. Only then, you could be able to add the domain on the cPanel.

For example, if the nameserver for the main domain is ns1.seekahost.info and ns2.seekahost.info, then the same nameserver must be updated for the addon domain in your domain registrar also.

Ensure you have Addon Availability in your cPanel Account. On the right side of your cPanel dashboard, you could see an option like Addon where you can see the allocation.
Check whether you have utilized the 100% disk usage or still you have enough space to create an Addon Domain. If your disk space is more than 95%, you will face the issue in adding the Addon Domain.
Make sure you are not using the reserved domain names while creating the Addon domains.

If you are still facing issue in adding the Addon domain, please contact SeekaHost on 24×7 Live support and share us the error screenshot.

Our experts will help you in solving it immediately and you can proceed with that.

[Tweet “These are the step by step guide to create an Addon domain in cPanel”]

How to Install Free SSL in cPanel?

Before getting into the topic “How to Install AutoSSL in cPanel?” we should be clear about why we need to install SSL for the websites?

One of the most important backbones of online business is just creating a secured and trusted environment.

So an SSL certificate creates a foundation of trust by providing a secure connection. It creates a secured connection between the client and a server. SSL encrypts the data/information sent across the internet.

This is because; the information that you sent on the internet will travel from one computer to another computer to reach its destination place.

Anyone in between you and the server can be able to access your data/information that passes through the internet if it’s not encrypted. If you installed an SSL certificate for your website, the information that you send through this site will become unreadable except the destination server.

Auto SSL

AutoSSL is one of the best features in cPanel & WHM. By using AutoSSL, it automatically installs and renews Let’s Encrypt SSL certificates for every domain. SSL Installation and Renewal is one of the complex tasks. So most of the web hosting providers comfort the clients with Auto SSL to do the tasks easily. Here, you don’t want to fill out any forms or install the certificates manually. Once you enabled AutoSSL, your websites will be automatically secured free, domain validated SSL certificate. AutoSSL will not force the site to load in https, it needs to be changed manually.

Here, I have explained you how to enable AutoSSL in cPanel.

How to Install Auto SSL in cPanel?

Login to the cPanel Account.
Search for SSL/TLS and click on that.

Below ‘Install and Manage SSL for your site (HTTPS)’, click on “Manage SSL Sites”.

There you can see the default SSL certificate for your domain which you want to uninstall now. So, click on “Uninstall”.

After that, go back to the cPanel home page and search for “SSL/TLS Status”

In SSL/TLS Status, click the domain checkbox and click “Run AutoSSL”

If the website loads with both http and https but you want to load only with https, kindly update the URL in phpMyAdmin -> Database -> wp_option and update the website name with HTTPS.
Also do force redirect on the “domains” section for the domain to redirect the website from http to https if visitor visit the website on http.

Force redirect SSL — Helps visitor to visit secure website and increase the trust.

[Tweet “Learn how to Install Free SSL in cPanel?”]

How To Create FTP Account on cPanel?

Creating an FTP account on cPanel:

An FTP account is mainly used for managing and uploading files on your website. It is a default option in cPanel when you start hosting your sites. You can create multiple FTP accounts to give access to other users without giving them your cPanel login details.

There are some easy steps you should follow to create an FTP account in cPanel they are:

STEP 1:

STEP 2:

In the Files section, click on the FTP accounts to create a new account.

STEP 3:

In the Add FTP account section, you can see the login field. Type the name of the FTP user. It will be formatted as user@domain For ex: [email protected]. You need the domain name to create an FTP account, which is mandatory.

In the password field, enter the password which you use to access the account or else the password can be generated automatically, by clicking on password generator.

In the directory field, you can give the location from which the particular user can access. If you are an Admin, you can leave it empty to access all the files.

The user can set the quota in the quota field. The quota is the maximum amount of bandwidth, a user can use. If you set the quota as unlimited, you can access the total amount of bandwidth for the cPanel account.

STEP 4:

Now, click on Create FTP account. A new FTP account will be created for the user.

You can check the Account details by clicking on “Configure FTP Client”

How to Disable Plugins through cPanel or FTP Access?

In WordPress, plugins makes the job very easy. WordPress brought a change that there is no need of coding to design or to develop a website. It is the simple way to update contents and to design a website. Few years back, to integrate something new we must have coding knowledge or else we must edit some core theme files. If you do anything wrong, then it will collapse the entire website. But nowadays you can find more plugins to configure the changes whatever you want. So plugins making the changes so easy and it is safe to do.

Why we need to Disable Plugins through cPanel or FTP?

Sometimes you may face issues in logging into your WordPress dashboard. Due to some improper updates and cache issues site may not load, so during that time it is difficult to login into the website. During that time, it is not possible to design the entire website from the start so you must do something to check whether the website issue is getting sorted. During the critical time you must try to disable plugins through cPanel or FTP.

How to Disable Plugins through cPanel?

You must have cPanel Access to make the changes.
Login into your cPanel Dashboard
Go to file manager.
Go to public_html -> wp-content -> plugin
To disable the plugin you must select the folder with plugin name & just rename it as disable or some other words.

How to Disable Plugins through FTP?

Login into your FTP Account using the access details.
Go to public_html -> wp-content -> plugin
To disable the plugin you must select the folder with the plugin name & just rename it as disable or some other words.

How to check by disabling the Plugins?

Just rename the plugin one by one and check whether the site is loading fine or not. Also don’t check the plugins randomly. Just make sure you disabling the cache or security plugins during the start. Because security and cache plugins alone will restrict the access. If you still facing this issue, then get support from the web hosting provider to recover your website at the earliest.

Step By Step Guide to Create a Subdomain in cPanel

Hosting is the base for every website. It is very important to provide a user-friendly interface to make effective usage of the features. Because even though there are thousands of features, you can use it only if it is easy to understand. So user interface must be easily understandable. So normally every hosting provider will provide the cPanel details for the users which is easy to understand.

What is a Subdomain?

A subdomain is a domain name that is followed by the main domain. For Example: Seekahost.com is a domain and blog.seekahost.com is a subdomain.

How to Create a Subdomain in cPanel?

In cPanel it is very simple and easy steps to create the subdomain. Just follow the below steps to create a subdomain in your account.

Login to your cPanel with your Account Details.
After login, you will see an interface like below. Sometimes it may vary just because of different themes.

In search, type “domains“, then you will get the results as shown below.

Click on the Domains.
Then you will be redirected to another page, where you can see the option to create a new domain.

Just click the “Create a New Domain” and you will see an option as the below image. There enter your subdomain name in the provided box and just make a click inside the document root text box. For example: I have used the domain wealthystreet.com and created the subdomain “demo”.

Click on Submit. Then your Subdomain is created.
To use the Subdomain, you must install CMS like WordPress.

Just follow the below steps to install WordPress and Use the subdomain.

Go to cPanel, and search for Softaculous.
Click on the Softaculous under software.
In Softaculous, go to WordPress installation. For more refer step by step guide to make use of a click installer.
Choose your subdomain and provide the needed details to install WordPress.

Click on Submit. Once after the installation, your subdomain is ready to design and use.
To check, go to cPanel and click on File Manager as shown below.

In Filemanager, Click on public_html.
Here you will see a folder in the name of your subdomain as shown in the below image.

Finally, you have created a subdomain and it is ready to use it.

For more, Visit -> seekahost.com/blog