Blog

install-SQL-Server-Management-Studio

How to install SQL Server Management Studio

The most popular SQL Server Management Studio (SSMS) is Microsoft official and recommended client user interface which can be used to manage, configure, deploy SQL Server instance and database objects.  The studio interface is very user friendly and comprehensive. It is shipped with every SQL Server version and is regularly updated and enhanced. If you are planning on learning how to use SQL Server from scratch, consider using SQL Server Management studio as a first step on your journey  on [...]

Read more...
How-to-uninstall-Cloudlinux-from-cpanel

How to uninstall Cloudlinux from cpanel

Uninstall Cloudlinux from cPanel  : # wget -O cldeploy http://repo.cloudlinux.com/cloudlinux/sources/cln/cldeploy # sh cldeploy -c Please, note that some of the packages from CloudLinux repo will still be present. They are same as CentOS packages, and don’t have to be removed. They will be updated in the future from CentOS repositories, as new versions come out. You can use below steps further: 1) Check if your server is Cloudlinux installed in it using below command. # /usr/local/cpanel/bin/cloudlinux_system_install -c 2) Update your CentOS-provided RPMs # yum upgrade -y 3) Rebuild [...]

Read more...
Tweaks-to-prevent-Spamming-on-cPanel-server

Tweaks to prevent Spamming on cPanel server

Spamming on cPanel server is very common if you have not applied any security and not taken proper steps to secure it. Exim mail server comes by default with cpanel and allows tweaks and settings to stop spamming on the server. In the following technical post we will show you to follow the tips and settings on cpanel server. Tweaks to prevent Spamming on cPanel server  Exim Configuration Manager 1. Login to WHM control panel by using root user 2. Goto Main [...]

Read more...
sysmbolic link

Symbolic link :- Adding and deleting

Symbolic Links refer to a symbolic path indicating the abstract location of another file i.e. symbolic links are files that act as pointers to other files. Symbolic Link is also known as symlink or soft link. Difference between soft link and hard link is that when symlink is removed the original target stays present. This is the opposite of a hard link which is a reference to the target and so, if the hard link is removed, so is the [...]

Read more...
reset-WordPress-admin-password-via-command-line

How to reset WordPress admin password via command line

We can reset WordPress admin passwords via command line in cPanel server for domains. First, we need to find which Database is used by the domain for WordPress. You can find it via checking the Database name given in the file ‘wp-config.php’. Upon finding that, login to MySQL prompt. # mysql mysql> use databasename; where databasename is the database in which WordPress is installed. mysql> SELECT ID,user_login,user_pass FROM wp_users; +—-+————+————————————+ | ID | user_login | user_pass | +—-+————+————————————+ | 1 | admin | $P$B05GJOhuMCFlxtYsYjA8P/sX0svNw81 | mysql> UPDATE wp_users SET user_pass [...]

Read more...
Clean-Eximstats-Database

How to Clean Eximstats Database

Generally eximstats database looks very small in size when Cpanel is installed. The database is setup by default when Cpanel installation on the server is completed. So what exactly is this database for. As the name suggests “exim stats” its clear that this mysql database generates statistics from exim main log file or syslog file.  But there is one issue with this database as over the time the size of this database gets increasing day by day depending on the log [...]

Read more...
server-management

Server Management

Server management is the maintenance and operation of a server. While this can mean many things, the main idea behind server management is uptime. The whole purpose of a server is to have a reliable resource for users to interact with. Management of a server can vary depending on the size of the server and it’s purpose. Different types of servers require different types of management plans. The following sections discuss “standard” server management techniques. These techniques may need [...]

Read more...
change-the-default-port-for-Plesk

How to change the default port for Plesk

It is not recommended to change the default Plesk port because it can break Plesk integration with other programs (like Plesk Expand or DrWeb). Linux :- 1.) To change the port Plesk listens on you will need to edit /usr/local/psa/admin/conf/httpsd.conf file and change the following directives to list the port you want Plesk to listen on: Listen 8443 Port 8443 <VirtualHost *:8443> 2.) You will need to restart Plesk afterwards and update the hardware object in the SoftLayer portal with the new port (Hardware > [...]

Read more...
configure-clustered-nameservers-on-cPanel-server

How to configure clustered nameservers on cPanel server

As you know the importance of having clustered nameservers on cPanel servers, once you setup DNS cluster then the chance for DNS appears down will be lowered.  This will be applicable for the user’s having more than one cPanel server, this can be done easily from your WHM. For that please follow the steps that we have mentioned below, 1. Make sure that you have enabled DNS Clustering on both your servers. This can be done from WHM, for that go [...]

Read more...
change-timezone-for-MySQL-on-a-cPanel-server

How to change timezone for MySQL on a cPanel server

For many of the websites there will be different time elements used for displaying time. It will use the server time this, but in some cases we need to have different time for the website and it is not possible to change the server time. So in that case we can change the timezone for MySQL to keep the website updated with the required timezone. For that first you need to know the function that will display the timezone for MySQL, [...]

Read more...