Search results

  1. bhawanisingh

    How to install Memcached on CentOS Linux server ?

    In this article we will learn how to install Memcached on CentOS linux server. But, first we will discuss what is Memcached and for what purpose it is used. What is Memcached ? Memcached is a open source distributed, high performance memory object caching program that is primarily used to...
  2. bhawanisingh

    How to change MySQL root password through WHM/SSH ?

    In this articel we will learn to change MySQL root password through WHM or SSH. Things to check, you must have root access for your server. This facility is available for Dedicated servers only and not for shared server users. MySQL root password is separate from main user root password. Now, we...
  3. bhawanisingh

    How to create a MySQL user on CentOS server and Grant permissions to it through command line ?

    To create MySQL user you should have root access for SSH. First of all you have to login to MySQL server through command line. ----- # mysql -u root -p ****** ----- Here, -u option is for username and -p option is for password. Now, you will be at MySQL prompt and it looks like this : ----- #...
  4. bhawanisingh

    [Resolved] error mysqld_safe - a mysqld process already exists.

    This error occurs basically when some one try to reset his MySQL password and any mysqld process is still running. Some days before one of my client ask me that he is getting problem to reset his MySQL password. He told me that he is getting some error "mysqld_safe A mysqld process already...
  5. bhawanisingh

    How to delete MySQL database through command line ?

    Sometimes we need to delete a MySQL database through command line. Before deleting a database you must check these points like you must have root access, before use DROP DATABASE you should check you have DROP privilages or not. First, we will login to the MySQL server through command line ...
  6. bhawanisingh

    How to list MySQL databases through command line ?

    To list MySQL databases you have to login as root user. You can use mysql command to list all available databases. MySQL is simple command line tool which is simple and easy in use. First, you have to login into the MySQL server through this command line ; ----- # mysql -u root -p ***** -----...
  7. bhawanisingh

    [RESOLVED] Error "Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

    This problem occurs when you run command "# mysql -u USER -p". It happens as MySQL is not running or installed on server. To rectify this we have first check whether MySQL is running or not. To check MySQL is Running or not type the following command: ---- # service mysqld status ---- You can...
  8. bhawanisingh

    Top SSH clients for Windows. Putty alternatives.

    SSH is called Secure Socket Shell. It is a network protocol which facilitates server admins to access a remote computer in a secure way. When we are talking about SSH clients on Windows system, first name came into our mind is Putty. Yes, it is widely used by every user as it is free and easy to...
  9. bhawanisingh

    How to execute MySQL queries from command line/Bash shell ?

    Many a times we need to run MySQL query directly from command line to perform certain tasks like backup of MySQL database or creation of MySQL database and users, without logging into MySQL prompt. You can either run a single query quickly from command line Or you can run queries from Bash...
  10. bhawanisingh

    How to setup DNS Resolution with "resolv.conf" file ?

    The "resolv.conf" is a file used to configure the system's Domain Name System (DNS) resolver which contains a list of nameservers IP addresses available for DNS resolution. It contains information which determines the operational parameters of the DNS Resolver. The DNS resolver translate the...
  11. bhawanisingh

    How to check SSL Certificate Expiration Date through command line on CentOS server ?

    An SSL Certificate Contains a lot of information about issuer(Who issued the SSL Certificate), Subject(To whom it is issued), Validity dates(date till it is valid) and many other stuff like Hash values and MD5 Fingerprint. Checking for SSL Certificate Expiration date and it's validity is quite a...
  12. bhawanisingh

    How to clear yum cache on CentOS linux server ?

    Yum - What it is ? Yum is Yellowdog Updater, Modified. It is command line package management utility which is open source and used for Linux systems. It allows package and dependency management, automatic updates on Linux systems. By default, it deletes all downloaded files which are no longer...
  13. bhawanisingh

    How to Lock and Unlock user account on CentOS Linux Server ?

    Sometimes you will need to lock an user of an account without suspending the whole account, for some security reason. Ans sometimes we need to unlock an user account which was get locked due to wrong password attempts or account expiry,etc. We can lock or unlock any user account by using two...
  14. bhawanisingh

    How to delete symbolic links in CentOS Linux servers ?

    Symbolic links : What are they ? Symbolic links act like pointers to another file which saves hardisk space on server. They are also called softlinks as by creating a simple link to the file can just save time and space on sevrer. If you delete a Symbolic link then it is similar to delete the...
  15. bhawanisingh

    [SOLVED] MySQL table repair error "Can't create new tempfile: '/*****/filename.TMD"

    In very rare conditions this error occurs while repairing your MySQL database table or whole database. This error occurs when you are trying to repair any crashed database table or database itself. Mostly, this occurs when WordPress "wp-posts" table crashed and you try to repair it. It is quite...
  16. bhawanisingh

    [SOLVED] Error cPanel "Your IP address has changed. Please log in again".

    Error cPanel "Your IP address has changed. Please log in again" This error occurs when your IP address chnaged while you logged into your cPanel control panel. There must be two possibilities behind this error messgae. 1). Either, Your Internet Servive Provider (ISP) has a short DHCP lease...
  17. bhawanisingh

    How to increase maximum execution time for PHP ?

    Many a times people get this error while uploading large files or big images through script. Or while updating their WordPress/Drupal account. Fixing this error is quite simple and easy but for beginners it's frustrating. In this article we will teach you how to fix this error. Well, as the...
  18. bhawanisingh

    Introduction to FirewallD CentOS 7. How to start and stop/disable it ?

    Introduction to FirewallD CentOS 7 : FirewallD is a complete firewall solution provided by default with CentOS 7. It control network traffic rules through IP tables and act as frontend controller. It is available with most Linux Distributions. The key features of FirewallD are that it uses zones...
  19. bhawanisingh

    How to find php.ini location on CentOS server ?

    What is php.ini file ? The php.ini file is the default configuration file for running applications that require PHP. It is used to control variables such as upload sizes, file timeouts, and resource limits. How to find php.ini location ? You can check php.ini file through two ways. 1). Through...
  20. bhawanisingh

    How to install CentOS Web Control Panel on CentOS system ?

    CentOS Web Panel is a free web hosting control panel which facilitates you to easily manage servers. The latest version of CentOS Web Panel 0.9.8.6 was released on 19th April 2015. This control panel is full with various features that provide an ease to manage and operate server operations...
Top