How to install mysqli extenstion through WHM?

Hello guys,

In the current days most of the CMS  uses mysqli for the database handling. If there is no mysqli installed on your server then you should have to install it. Here I can show you easy way to install it through WHM >> Easy Apache.

The MySQLi Extension is a relational database driver used in the PHP programming language to provide an interface with MySQL databases. You may refer wiki for more information.

1. Once you logged into the WHM, search for “EasyApache” or travel to Menu Software > EasyApache 3

2. Scroll down  the page and select a build option with Previously Saved Config profile.

4. Click Start “Start customizing based on profile”

5. Select the version of Apache and click “Next Step”.

6. Select the version of PHP and click “Next Step”.

7. Chose additional options within the “Short Options List”

8. Select “Exhaustive Options List” and look for “MySQL Improved extension”

9. Click “Save and Build”

To check mysqli is installed or not :-

Run the command on server as below. If this command will not give any output means mysqli is not installed.

Quote

#php -i|grep -i mysqli

Thank you.

 

 

 

 

How to enable temporary website URL?

Hello Folks,

Got time to make this post so here you can how enable it. It’s simple and helpful if you don’t have any domain registered you may test all the things on the temporary URL and then make it live.

To enable temporary URL (http://xxx.xxx.xxx.xx/~username.)login to the WHM as a root user.

Now travel to “Security Center >> Apache mod_userdir Tweak”

 

Tick the check box “Enable mod_userdir Protection” and exclude “DefaultHost (nobody)”

Save it and now you are able to use temporary URLs.

 

 

 

 

How to suspend and un suspend email accounts through cPanle?

Hello folks,

cPanel has launched new feature with new cPanel version 11.54 that using you may suspend a single email account and secure your accounts. This feature helps to hosting companies if there is any email account gets compromised and sent spam mails then from now they can suspend compromised email account instead of suspend whole cPanel account.

Login to your cPanel account and go to Email account. Refer above image for more above help. Thank you.

About

Visit the post for more…!

Source: About

How to Increase Import File Size Limit in phpMyAdmin?

Hello Folks,

Sometimes you guys you need to upload big file of database through PhpMyAdmin and if it is not allowing you to upload more than 50MB even upload_max_filesize limt has set greater than 50MB then it should be a limit that in PhpMyAdmin that doesn’t allowing you to upload flie size more than 50MB. See below image to increase a limit.

Login to WHM with root user.

1. Go to Tweak settings, find the “cPanel PHP Max upload size” change it that you want. Click on the Save changes.

2. Go to Tweak settings, find the “cPanel PHP Max POST size” change it to bigger than upload limit. Click on the Save changes.

Now go to your PhpMyAdmin, you can see the value that you have set in import section.

That’s it !! 🙂

How to export/take backup of database through PhpMyAdmin?

Hello Folks,

It’s very good thing that keep backup of database doesn’t matter is your hosting partner it take’s daily basis or not. You should have a copy of it. Here I am going to show you how to take the backup or how to export database from PhpMyAdmin.

1. Login to cPanel.
2. Click on the “phpMyAdmin” icon that located under the “Databases” category.
3. After entered into phpMyAdmin, select a  desired database to export from the list on the left side of screen.
4. Click on the “Export” tab and select an export option:

Quick – Export the entire database using the default options.

Custom – Select specific tables within the database to export, or change the individual export options.

5. Click on the “Go” button and the database export will begin.

 

How to check PHP versions and parameters that set on your hosting server?

Hello Gusy,

It’s very easy to get the information of PHP version and parameters on which your website hosted. Most Hosting company never shares these information but you can check it as mentioned below.

To check it you need to create one PHP file by any name. Here, I am using phpinfo.php and adding below one lins code into it.

<?php phpinfo() ?>

Save and close the file.

Now open URL like http://mydomain.com/phpinfo.php and you will see all the set parameters and PHP version that installed on the server.

That’s all ! 🙂

How to set perfect SPF for domain?

Hello folks,

SPF is nothing but a Sender Policy Framework which helps to prevent outgoing spam mails from your domain. It’s generally specify a server or a IP address to your domain that authorized to send mails.

Here we’ll see which are the best SPF record that we can set for domain. It’s not too difficult, send one mail to your Gmail’s account and see the Original Headers of mail. Look for line mentioned below.

Received-SPF: neutral 

Here it is showing “neutral” for the values that you have set in SPF record in domain’s zone file. It should be “pass” otherwise your mail’s will land into spam/junk box or will be rejected sometimes.

To set Perfect SPF record check with your hosting provider for the server’s main IP address or mail server IP address. Once you get it, ask them to update your SPF record to which should include mail server IP looks like as below.

v=spf1 +a +mx +ip4:xxx.xxx.xxx.xx -all

You can enable SPF from cPanel >> Email >> Authentication.

That’s all.

How to enable SSH access for the cPanel account in WHM?

Hello Folks, 

In this post I cover how to enable SSH access for an ordinary account created by you on your WHM server. Follow the steps listed below: 

1. Login to the WHM and navigate to Account Functions > Modify an Account.

2. Activate the SSH access for the account through the Shell Access [ Jailed shell / Normal shell] radio button in front of 

How can you use it? 

If you are using Windows O.S then download and open the putty software on you machine and in Host Name (or IP address) type server’s IP address or domain that pointing to the server. Type port 22 otherwise your custom port for the SSH if you have configured. Connection type should be SSH. Now click on Open button. 

Use your cPanel’s account username and password to proceed further. 

If you are on Linux based O.S, run the following command on your terminal. 

That’s all and you can save your time by running commands instead of using GUI. 

.

How to install SSL certificate in WHM server?

Hell mates,

It’s very simple to install SSL on the WHM server. In this post I assume that you have already purchased a SSL certificate from the SSL provider for the domain on which you going to install it. If not you have to first purchase SSL certificate.  Follow the steps listed below:

1. Login to your (WHM) control panel.

2. On the left side menu, click on go to SSL/TLS >> Install an SSL Certificate on a Domain. 

3. In Domain type your domain name, in Certificate paste your certificate. In Private key paste your key that generated at the time to creation of CSR. In Certificate Authority Bundle paste your CA bundle that you have receive with the SSL certificate. If not get it from your SSL certificate provider.

That’s all. You’r done. There are may online tool to check your SSL ceritficate. You can use them to check if it is installed properly or not, Now enjoy your can access website over the https:// protocol.