Monthly Archives - April 2015

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...
How-to-check-mysql-processlist

How to check mysql processlist on a cPanel server

There are different ways for checking mysql processlist from a cPanel server. As you all know for most of the production server it is needed to check mysql process list for checking the currently running queries and for finding slow queries that slow down the website loading speed. You can check MySQL process list from command line in the following ways, Enter into mysql from command line using the command, mysql After that use the command, show processlist; For example: root@srv24x7 [~]# mysql Welcome to the MySQL [...]

Read more...
24x7servermanagement