Author Archive

How to export database table through phpMyAdmin in cPanel?

1. Log into your cPanel account.

2.click on “phpMyAdmin” Icon, In the “Databases” section.

chwkb-phpmyadmin-icon

3. In left side-bar, Click on the expand button to expand database like “example”.

chwkb-phpmyadmin-expand-db

4. You can see a list of all databases under cPanel username. Choose appropriate database which you want to export it to your PC.

chwkb-phpmyadmin-db-list

5. Click on the “Export” button.

chwkb-phpmyadmin-export

6. Select SQL format and then click on the “Go” button.

SQL file will be downloaded within few seconds but If size is large then it will take a long time.

How to export database table through phpMyAdmin in cPanel?

1. Log into your cPanel account.

2.click on “phpMyAdmin” Icon, in the “Databases” section.

chwkb-phpmyadmin-icon

 

3. In left side-bar, Click on the expand button to expand database like “example”.

chwkb-phpmyadmin-expand-db

4. You can see a list of all databases under cPanel username. Choose appropriate database which you want to export it to your PC.

chwkb-phpmyadmin-db-list

5. Click on the “Export” button.

chwkb-phpmyadmin-export

6. Select SQL format and then click on the “Go” button.

SQL file will be downloaded within few seconds but If size is large then it will take a long time.

How to import database via phpMyAdmin in cPanel?

1. Log into your cPanel account.

2. Click on “phpMyAdmin” Icon, In the “Databases” section.

chwkb-phpmyadmin-icon

3. Click on the expand button to expand database like “example”, In left side-bar.

chwkb-phpmyadmin-expand-db

4. Beneath your cPanel username, you can get a list of all databases. Choose a proper database in which you want to import SQL.

5. Click on the “Import” button.

chwkb-phpmyadmin-import

6. Under “File to Import” click on the “Browse” button, Select SQL file from your PC.

chwkb-phpmyadmin-import2

7. Scroll down and then click on the “Go” button.

If its show a message in the green box then it means your SQL is successfully uploaded.

chwkb-phpmyadmin-successfully

 

How to add a user to a privileges and add database?

1. Log into your cPanel account.
2. In the “Databases” section, click on “MySQL Databases” Icon.

3. Scroll right down to the top of the page and below “Add User to Database”, choose a user from the dropdown list, so select a information from the list.

4. Click on the “Add” button.

chwkb-add-db

click on “Make Changes and On “Manage User Privileges”, mark the box “ALL PRIVILEGES”

chwkb-add-privileges

How to add a user to a privileges and add database?

1. Log into your cPanel account.
2. In the “Databases” section, click on “MySQL Databases” Icon.

chwkb-mysql-databases-icon

3. Scroll right down to the top of the page and below “Add User to Database”, choose a user from the dropdown list, so select a information from the list.

4. Click on the “Add” button.

chwkb-add-db

click on “Make Changes and On “Manage User Privileges”, mark the box “ALL PRIVILEGES”

chwkb-add-privileges

How to Install MovableType via Softaculous in cPanel?

1. Log into your cPanel account.

2. In the “Software” section, you need to hit on “Softaculous App Installer” Icon.

chwkb-softaculous-icon

3. When you click on “Softaculous App Installer” Icon cPanel will revert you to the Softaculous Panel.

4. On the left side of your screen, you should locate the “Blogs” category. Click on it and then click on the “MovableType” link that will be displayed on the screen.

chwkb-MovableType-softaculous

5. Click on the “Install” button

chwkb-MovableType-install-button

6. Fill up the needed essentials in the “Software Setup” option:
Choose Protocol: You can leave this as it is.
Choose Domain: If you don’t have multiple domains, leave this as it is.
In Directory: If you would like to install this in a directory, for example, example.com/directory, just mention the directory name. Or you can just leave it blank to install in your main domain example.com
Web Directory: Leave this as it is.

7. Under the “Site Settings” field:
Site Name: Mention the name of your website, as “my first website”
Site Description: Site Description

chwkb-MovableType-install-screen2
8. Under the “Admin Account” field fill up the subsequent information:
Admin Username: Your new MovableType username (for security reason do not use the “Administrator” or the “Admin” username.)
Admin Password: Use a strong password.
First Name: Your first name.
Last Name: Your last name.
Admin Email: Your e-mail address.

Note: Copy the admin username and password on a notepad as the login particulars are essential to access the admin area of your MovableType blog.

chwkb-MovableType-screen2

9. Advanced Options: Leave this as it is unless you want to change the database name or take an automated backup. Please see to it that you are not taking too many constant backups as it may take a lot of disk space.

Lastly, scroll down to the end of the page and click on the Install Button

chwkb-softaculous-install-button

How to Install HTMLy via Softaculous in cPanel?

1. Log into your cPanel account.

2. In the “Software” section, you need to hit on “Softaculous App Installer” Icon.

chwkb-softaculous-icon

3. When you click on “Softaculous App Installer” Icon cPanel will revert you to the Softaculous Panel.

4. On the left side of your screen, you should locate the “Blogs” category. Click on it and then click on the “HTMLy” link that will be displayed on the screen.

chwkb-HTMLy-softaculous

5. Click on the “Install” button

chwkb-HTMLy-install-button

6. Fill up the needed essentials in the “Software Setup” option:
Choose Protocol: You can leave this as it is.
Choose Domain: If you don’t have multiple domains, leave this as it is.
In Directory: If you would like to install this in a directory, for example, example.com/directory, just mention the directory name. Or you can just leave it blank to install in your main domain example.com

chwkb-HTMLy-install-screen

7. Under the “Admin Account” field fill up the subsequent information:
Admin Username: Your new HTMLy username (for security reason do not use the “Administrator” or the “Admin” username.)
Admin Password: Use a strong password.
Admin Email: Your e-mail address.

chwkb-HTMLy-screen2

Note: Copy the admin username and password on a notepad as the login particulars are essential to access the admin area of your HTMLy blog.

8. Advanced Options: Leave this as it is unless you want to change the database name or take an automated backup. Please see to it that you are not taking too many constant backups as it may take a lot of disk space.

Lastly, scroll down to the end of the page and click on the Install Button

chwkb-softaculous-install-button

How to delete a database in cPanel?

1. Log into your cPanel account.
2. click on “MySQL Databases” Icon, under the “Databases” section.

chwkb-mysql-databases-icon

3. UBeneath “Current Databases”, You can see the list of your all databases. Find the Database then click on “Rename” Icon.

chwkb-delete-db

4. Click on the “Delete Database” button.

5. When you see a warning, click on the “Delete Database” button.

chwkb-db-remove-confirmation

How to Install FlatPress via Softaculous in cPanel?

1. Log into your cPanel account.

2. In the “Software” section, you need to hit on “Softaculous App Installer” Icon.

chwkb-softaculous-icon

3. When you click on “Softaculous App Installer” Icon cPanel will revert you to the Softaculous Panel.

4. On the left side of your screen, you should locate the “Blogs” category. Click on it and then click on the “FlatPress” link that will be displayed on the screen.

chwkb-FlatPress-softaculous
5. Click on the “Install” button

chwkb-FlatPress-install-button

6. Fill up the needed essentials in the “Software Setup” option:
Choose Protocol: You can leave this as it is.
Choose Domain: If you don’t have multiple domains, leave this as it is.
In Directory: If you would like to install this in a directory, for example, example.com/directory, just mention the directory name. Or you can just leave it blank to install in your main domain example.com

chwkb-FlatPress-install-screen

7. Under the “Admin Account” field fill up the subsequent information:
Admin Username: Your new FlatPress username (for security reason do not use the “Administrator” or the “Admin” username.)
Admin Password: Use a strong password.
Admin Email: Your e-mail address.

chwkb-FlatPress-screen2
Note: Copy the admin username and password on a notepad as the login particulars are essential to access the admin area of your FlatPress blog.

8. Advanced Options: Leave this as it is unless you want to change the database name or take an automated backup. Please see to it that you are not taking too many constant backups as it may take a lot of disk space.

Lastly, scroll down to the end of the page and click on the Install Button

chwkb-softaculous-install-button

How to rename a database in cPanel?

1. Initialize your cPanel account.
2.click on “MySQL Databases” Icon, under the “Databases” section.

chwkb-mysql-databases-icon

3. Beneath “Current Databases”, You can see the list of your all databases. Find the Database then click on “Rename” Icon.

chwkb-rename-db

4. Change database name and then click on “Proceed” button.

chwkb-change-dbname

How to Install PivotX via Softaculous in cPanel?

1. Log into your cPanel account.

2. In the “Software” section, you need to hit on “Softaculous App Installer” Icon.

chwkb-softaculous-icon

3. When you click on “Softaculous App Installer” Icon cPanel will revert you to the Softaculous Panel.

4. On the left side of your screen, you should locate the “Blogs” category. Click on it and then click on the “PivotX” link that will be displayed on the screen.

chwkb-PivotX-softaculous
5. Click on the “Install” button

chwkb-PivotX-install-button

6. Fill up the needed essentials in the “Software Setup” option:
Choose Protocol: You can leave this as it is.
Choose Domain: If you don’t have multiple domains, leave this as it is.
In Directory: If you would like to install this in a directory, for example, example.com/directory, just mention the directory name. Or you can just leave it blank to install in your main domain example.com

7. Under the “Site Settings” field:
Site Name: Mention the name of your website, as “my first website”

chwkb-PivotX-install-screen

8. Under the “Admin Account” field fill up the subsequent information:
Admin Username: Your new PivotX username (for security reason do not use the “Administrator” or the “Admin” username.)
Admin Password: Use a strong password.
Nickname: Nickname for the admin user account.
Admin Email: Your e-mail address.

Note: Copy the admin username and password on a notepad as the login particulars are essential to access the admin area of your PivotX blog.

chwkb-PivotX-screen2

9. Advanced Options: Leave this as it is unless you want to change the database name or take an automated backup. Please see to it that you are not taking too many constant backups as it may take a lot of disk space.

Lastly, scroll down to the end of the page and click on the Install Button

chwkb-softaculous-install-button

How to Create a Database Username in cPanel?

1. Log into your cPanel account.
2. click on “MySQL Databases” Icon, under the “Databases” section.

chwkb-mysql-databases-icon

 

3. Beneath “Current Databases”, You can see the list of your all databases. Find the Database then click on “Rename” Icon.
4. Enter your new password or use a password generator.
5. Click on the “Create a User” Button.

chwkb-createdb-user

 

How to Install eggBlog via Softaculous in cPanel?

1. Log into your cPanel account.

2. In the “Software” section, you need to hit on “Softaculous App Installer” Icon.

chwkb-softaculous-icon

3. When you click on “Softaculous App Installer” Icon cPanel will revert you to the Softaculous Panel.

4. On the left side of your screen, you should locate the “Blogs” category. Click on it and then click on the “eggBlog” link that will be displayed on the screen.

chwkb-eggBlog-softaculous

5. Click on the “Install” button

chwkb-eggBlog-install-button

6. Fill up the needed essentials in the “Software Setup” option:
Choose Protocol: You can leave this as it is.
Choose Domain: If you don’t have multiple domains, leave this as it is.
In Directory: If you would like to install this in a directory, for example, example.com/directory, just mention the directory name. Or you can just leave it blank to install in your main domain example.com

7. Under the “Site Settings” field:
Site Name: Mention the name of your website, as “my first website”
Site Description: Site Description

chwkb-eggBlog-install-screen

8. Under the “Admin Account” field fill up the subsequent information:
Admin Username: Your new eggBlog username (for security reason do not use the “Administrator” or the “Admin” username.)
Admin Password: Use a strong password.
Admin Email: Your e-mail address.

chwkb-eggBlog-screen2

Note: Copy the admin username and password on a notepad as the login particulars are essential to access the admin area of your eggBlog blog.

Choose Language: You can choose the language of your egg blog. The default language of eggBlog is English.

9. Advanced Options: Leave this as it is unless you want to change the database name or take an automated backup. Please see to it that you are not taking too many constant backups as it may take a lot of disk space.

Lastly, scroll down to the end of the page and click on the Install Button.

chwkb-softaculous-install-button

How to Install Chyrp via Softaculous in cPanel?

1. Log into your cPanel account.

2. In the “Software” section, you need to hit on “Softaculous App Installer” Icon.

chwkb-softaculous-icon

3. When you click on “Softaculous App Installer” Icon cPanel will revert you to the Softaculous Panel.

4. On the left side of your screen, you should locate the “Blogs” category. Click on it and then click on the “Chyrp” link that will be displayed on the screen.

chwkb-Chyrp-softaculous

5. Click on the “Install” button.

chwkb-Chyrp-install-button

6. Fill up the needed essentials in the “Software Setup” option:
Choose Protocol: You can leave this as it is.
Choose Domain: If you don’t have multiple domains, leave this as it is.
In Directory: If you would like to install this in a directory, for example, example.com/directory, just mention the directory name. Or you can just leave it blank to install in your main domain example.com

7. Under the “Site Settings” field:
Site Name: Mention the name of your website, as “my first website”
Site Description: Site Description

chwkb-Chyrp-install-screen

 

8. Under the “Admin Account” field fill up the subsequent information:
Admin Username: Your new Chyrp username (for security reason do not use the “Administrator” or the “Admin” username.)
Admin Password: Use a strong password.
Admin Email: Your e-mail address.

chwkb-Chyrp-screen2

Note: Copy the admin username and password on a notepad as the login particulars are essential to access the admin area of your Chyrp blog.

9. Advanced Options: Leave this as it is unless you want to change the database name or take an automated backup. Please see to it that you are not taking too many constant backups as it may take a lot of disk space.

Lastly, scroll down to the end of the page and click on the Install Button.

chwkb-softaculous-install-button

How to Enable the Two-Factor Authentication on Your cPanel Account?

Security is very important for our information safe and that we steered you change the Two-Factor Authentication(2FA) on your cPanel account so hackers are going to be unable to access your cPanel account albeit they need somehow access your account”s user and word details.

What are the Requirements?
You will be required a smartphone with a supported time-based one-time password app. Mobile Phone like Android, Windows, and Blackberry have an application for 2FA.

How to Enable the Two-Factor Authentication on Your cPanel Account?
1. Log into your cPanel account.
2. In the “Security” area, press on the “Two-Factor Authentication” Icon.

chwkb-cpanel-two-factor-authentication-icon

3. Under Step 1, Scan QR code applying your Google Authenticator or 2FA Authenticator APP and if your APP doesn’t”t have a QR Code reader, you can manually enter the Account name and Key number.

chwkb-cpanel-two-factor-authentication-pic

4. In Step 2, in the “Security Code” text box, fill up your Two-Factor Authentication code and press the “Configure Two-Factor Authentication” button.
chwkb-cpanel-two-factor-authentication-step2

You will see a message, appreciate “Success: Two-factor authentication is currently organized on your account”.

 

How to Install Nucleus via Softaculous in cPanel?

1. Log into your cPanel account.

2. In the “Software” section, you need to hit on “Softaculous App Installer” Icon.

chwkb-softaculous-icon

3. When you click on “Softaculous App Installer” Icon cPanel will revert you to the Softaculous Panel.

4. On the left side of your screen, you should locate the “Blogs” category. Click on it and then click on the “Nucleus” link that will appear.

chwkb-Nucleus-softaculous

5. Click on the “Install” button.

chwkb-Nucleus-install-button

6. Fill up the needed essentials in the “Software Setup” field:
Choose Protocol: You can leave this as it is.
Choose Domain: If you don’t have multiple domains, leave this as it is.
In Directory: If you would like to install this in a directory, for example, example.com/directory, insert the directory name. Or you can just leave it blank to install in your main domain example.com

7. Under the “Site Settings” field:
Site Name: Mention the name of your website, as “my first website”
Site Short Name: Short name

8. Under the “Admin Account” field fill up the subsequent information:
Admin Username: Your new Nucleus username (for security reason do not use the “Administrator” or the “Admin” username.)
Admin Password: Use a strong password.
Real Name: Leave this as it is or enter your real name.
Admin Email: Your e-mail address.

Note: Copy the admin username and password on a notepad as the login particulars are essential to access the admin area of your Nucleus blog.

chwkb-Nucleus-install-screen

9. Advanced Options: Leave this as it is unless you want to change the database name or take an automated backup. Please see that you are not taking too many constant backups as it may take a lot of disk space.

Lastly, scroll down to the end of the page and click on the Install Button.

chwkb-softaculous-install-button

How to Enable or Disable Mod Security in cPanel?

Is your IP address frequently blocked when you access a WordPress admin section or any type of script with a web browser? Are you left with the feeling that your IP is blocked or that the server is down or isn”t working?

If the answer is “Yes”, then it may have as a result of Mod Security.

What is Mod Security?

To protect your website from attacks ModSecurity is the best module.

Mod Security protects the website from hackers, attacks, a brute force attack, a cross-site request forgery(CSRF) and many other threats. Although it sometimes creates a problem, we do not suggest you disable it but instead, fix your software vulnerability.

Disabling ModSecurity can guide you to determine whether your IP or your client/visitor”s IP is blocked by ModSecurity. If it isn”t the case, however, it means that your IP is blocked for the other reason. However, if you are sure about that ModSecurity that is the reason your IP is blocked, then contact us and we will show the exact reason behind that, in order to solve your issue so that you will not be required to disable the module.

How to Enable or Disable Mod Security in cPanel?
1. Log into your cPanel account.
2. In the “Security” area, press on the “ModSecurity” Icon.

chwkb-mod-security-icon

3. If ModSecurity is enabled, it shows a “Disable” option, press on it and ModSecurity will be disabled on your domains names. Next time, if you want to enable it, you will only need to press on “Enable”. This will enable it on all domains.

chwkb-disable-modsecurity-in-cpanel

How to Disable ModSecurity Only on Selected Domains and not on All Domains?
If it is possible various domains and you want to disable or enable ModSecurity only on selected domains.

1. Login to cPanel from the “Security” area and press on the “ModSecurity” Icon.

2. Scroll down to the bottom of the page.
3. Under the “Status” option next to the domain, press on “On” or “Off”.

chwkb-modsecurity-disable-selected-domain-cpanel

How to Install the SolusVM Slave on CentOS 7?

The SolusVM is an also known as VPS hosting Cpanel and for generating VPSs on this server, the SolusVM Slave is installed on a dedicated server.

What are the requirements?
– Fresh CentOS 7, installed on your VPS/Server.

How to install SolusVM Master?

Step 1: Login to SSH as a root account and run these 2 commands:
wget https://files.soluslabs.com/install.sh
sh, install.sh

2. Then it will show you an option to choose virtualization. Most people prefer KVM and others Xen. Select your preferred virtualization by typing 1 or 2 and then press Enter. For KVM, we enter 2 and then hit Enter.

chwkb-solusvm-slave-chose-virtualization

Installation can take from 15 to 20 minutes.

Once it completes, it will show you the Slave keys and further instructions for your virtualization type. Now you can use these keys to add a node to your SolusVM Master panel. You will need a SolusVM Slave license for each node.

chwkb-solusvm-slave-keys-of-installation

How to Install Pixie via Softaculous in cPanel?

1. Log into your cPanel account.

2. In the “Software” section, you need to hit on “Softaculous App Installer” Icon.

chwkb-softaculous-icon

3. When you click on “Softaculous App Installer” Icon cPanel will revert you to the Softaculous Panel.

4. On the left side of your screen, you should locate the “Blogs” category. Click on it and then click on the “Pixie” link that will be visible on the screen.

chwkb-Pixie-softaculous

5. Click on the “Install” button.

chwkb-Pixie-install-button

6. Fill up the needed essentials in the “Software Setup” field:
Choose Protocol: You can leave this as it is.
Choose Domain: If you don’t have multiple domains, leave this as it is.
In Directory: If you would like to install this in a directory, for example, example.com/directory, insert your directory name.Or you can just leave it blank to install in your main domain example.com

7. Under the “Site Settings” field:
Site Name: Mention the name of your website, as “my first website”
Site Description: Site Description

8. Under the “Admin Account” field fill up the subsequent information:
Admin Username: Your new Pixie username (for safety purpose do not use the “Administrator” or the “Admin” username.)
Admin Password: Use a strong password.
Real Name: Leave this as it is or enter your real name.
Admin Email: Your e-mail address.

Note: Copy the admin username and password on a notepad as the login particulars are essential to access the admin area of your Pixie blog.

9. Advanced Options: Leave this as it is unless you want to change the database name or take an automated backup. Please note that taking frequent backups may take a lot of disk space.

And at the last, scroll down to the end of the page and click on the Install Button.

Need Help?

Connect to our 24*7 Technical Support Team