How to Change your WordPress Username, Nickname and Display Name in MySQL
After you create an account log in WordPress, you may want to change your WordPress username, as appropriate or due to security reason. However, you can not do this from…
How to Install MySQL on CentOS 7 / RHEL 7 / Oracle Linux 7
In this quick guide, i will show you how to install MYSQL on CentOS 7 / RHEL 7 / Oracle Linux 7 instead of MariaDB. MariaDB is the default implementation…
How to Enable and Grant Remote Access to MySQL Database Server
For reasons of security, remote access to MySQL database server is disabled by default because they are considered potential security threats. However, due to some reason, it is necessary to…
How to Calculate and List Sizes of MySQL / MariaDB Databases
Question : I am finding the best way to calculate and list sizes of MySQL or MariaDB Databases ? Answer : In order to achive this, please do the following….
How to Change the WordPress URLs in MySQL Database
Before this I have experienced issues in wordpress migration of servers moving from the test server with an unregistered domain URL (www.ehowstuff.local) to the new virtual private server (VPS) with…
How to Install Nginx 1.6.2 with PageSpeed on Linux CentOS 6
This article will show you the steps to install Nginx and ngx_pagespeed module on Linux CentOS 6 virtual private server (VPS). By using ngx_pagespeed, the speed of your website will…
How to Secure MySQL Server on CentOS 6.5 / CentOS 6.6
MySQL is the world’s most popular open source database and its the world’s second most widely used open-source relational database management system (RDBMS). MySQL default installation is not securely configured….
How to Install Lighttpd With PHP5 (PHP-FPM) and MySQL on CentOS 6.5
Lighttpd (pronounced “lighty”) is an open-source web server as an alternative to Apache and Nginx. It is a secure, flexible, fast and designed for speed-critical environments. It has a low…
How to Install and Configure Apache2, PHP and MySQL 5.6 on Ubuntu 14.04
LAMP stack is a group of open source software that installed together to let you run a server to host dynamic websites. “L” stand for Linux, “A” stand for Apache…
How to Setup WordPress on Nginx, PHP-FPM and MySQL
WordPress website can be served using Apache or NGINX. Apache is the most popular Web server and most widely used for WordPress blogging platform. Apache is a great option and…
How to Display processlist in MySQL
MySQL databases are great database in internet. It’s commonly used in WordPress and Drupal blog. When you are monitoring the performance of a WordPress or Drupal blog, do not forget…
How to Secure your MySQL On VPS or Dedicated Server
Running a WordPress on a Virtual private Server or dedicated server is not an easy as running a WordPress on shared hosting server. There are a few things need to…