Setting or Changing MYSQL Root Password

Setting/changing MYSQL root Password
Setting up mysql database password is one of the important tasks which a webmaster should take care of. If you have never set a root password for MySQL, then server does not require a password at all for connecting as root and if you have already set password for your database and for some reason if you want to change it then you can do so using following commands.
To setup root password for MySQL databases for first time you need to login to your server as root and will have to use mysqladmin command at shell prompt as follows:

$ mysqladmin -u root password “mysql_password“

However, if you want to change/update your root password, then you will have to use following command

$ mysqladmin -u root -p oldpassword newpassword

after you fire above command you will have to provide password for your MySQL database.

Installing SSL on server using WHM

Almost all webmaster try to have SSL certificate on their ecommerce sites so that all transactions can be done securely. Domain which need to have SSL certificate should be hosted on dedicated IP where you can install SSL certificate for it. You can order SSL certificate from any provider and can install it for your domain. Once you have generated or received an SSL certificate, you can install the certificate using WebHost Manager. You need to have both the certificate and key files to install the certificate. Following steps would be helpful for you to install SSL certificate.
*) Login to WHM.
*) Click on Install an SSL Certificate and Setup the Domain under the SSL/TLS menu.
*) Enter the domain, user name, and IP address for the certificate in the Domain, User, and IP Address fields.
*) Click on the Fetch button to paste the .key and .crt files for the domain into the fields, if they are currently on your server. Otherwise, copy and paste the .key and .crt files into the available display areas.
*) Paste the ca bundle for the certificate in the bottom display area
*)Click on the Submit button.
that’s all you have successfully installed an SSL certificate for req

How to trap cPanel ( WHM ) Password Modification

If your account is hosted on Linux hosting server then most webhosting service provider will offer you WHM/cPanel as hosting control panel depending on hosting package you choose. WHM/cpanel offer you large number of features using which you can manage your hosting account or website very easily. you can set/reset password of cpanel, can manage email accounts, hosting accounts, can easily disk quota, create FTP accounts, setup CMS etc….. Most important feature you have with these control panels is that you can change password of cpanel using cpanel aswell as WHM. You may have to change reset your control panel password for some security reason, thus this feature is very important for all webmasters.

If you want to know the password which have changed password of cpanel then you need to create a module in /usr/local/Cpanel/ChangePassword/. This will run as root when password is changed in WHM or cPanel.

Module features :
You can access following variables using above module :
- user (string) - Account Username
- newpass (string) - Account Password
- message (string)*** - Password Change Status Message
- rawout (string)*** - Password Change output
- service_ref (string)*** - Password Change Service

Thus in order to access above module you will have to do the following :

#!/usr/bin/perl
package Cpanel::ChangePassword::Sendtobilling;
use strict;

my %OPTS = @_;
my $user = $OPTS{’user’};
my $newpass = $OPTS{’newpass’};
#Add function to create object and password send

Username / Password can then be send to remote location thus you can retrieve password which have tried to change password of cpanel.

Unblock IP using CSF firewall - VPS server

Following steps would help you to Unblock IP address you have blocked through CSF firewall. First of all you need to login to your VPS server using SSH access, then need to access APF firewall located under /etc/csf
you just need to edit csf.deny using vi csf.deny you need to remove IP address which you want to unblock from this file. Once you have edited above file you need to restart Firewall. For restarting Firewall you can use csf –r

Secure backup server

Backups plays an important role when your server crash and you lost all your data, you can restore all your webfiles and can get your site up and running through your offsite backupaccount. Usually all webhosting service provider will offer you backup space on their remote server where you can upload backup copies of your webfiles, databases. If  you are connecting your server backup using some custom software or script then there can be a risk for using such custom applications as if your local machine gets compromised then hacker can easily login to your remote backup space and can delete all your data through this custom software. Thus its always recommended to go with a host who don’t use any such custom application for allowing users to login to your backup space rather go with a webhost who would initiates data transfer from their remote backup servers (using scp scripts or RSYNC over SSH) – thus your server doesn’t have a direct access to backup data directory. This will avoid any backup data loss as if you are using any custom application software for connecting to your backup server and your local machine gets hacked then hacker can easily login to your remote backup server and can delete all data from your server. Its better to check with your webhost about what kind of connection do they offer you for connecting with your remote server. Don’t go with any host who is offering you some script or software for getting