Sometimes MySQL developers need to unpivot table in MySQL. Here are the steps to unpivot MySQL database table.
How to Unpivot Table in MySQL
How to Enable GZIP Compression in Apache Server
Enabling data compression in Apache server improves site speed. Here is how to enable GZIP compression in Apache server.
How to Upgrade Apache Server in CentOS, Redhat, Linux
It is important to upgrade Apache server for latest features and bug fixes. Here are the steps to upgrade Apache server in CentOS/Redhat Linux.
How to Block Image Hotlinking But Allow Google
Often site administrators need to block image hotlinking but allow Google search. Here are the steps to implement it.
How to Remove Trailing Slash in NGINX
Sometimes you may need to drop trailing slash in URLs. Here is how to remove trailing slash in NGINX server.
How to Change Port Number in Apache
Often system administrators need to run Apache server on different port. Here is how to change port number in Apache server.
How to Password Protect Directory in Apache
Sometimes you may need to enable password protection in Apache server. Here are the steps to password protect directory in Apache server.
How to Change NGINX Port Number in Ubuntu
Sometimes you may need to change NGINX port number. Here are the steps to run NGINX on different port number.
How to Enable CORS in NGINX
Sometimes you may need to enable CORS in NGINX in server. Here is how to allow cross-domain requests in NGINX.
How to List All Users in PostgreSQL
Often database administrators need to find out all users in PostgreSQL system. Here is how to list all users in PostgreSQL.