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…
5 Key Steps to Ensuring Database Security
Databases often contain extremely sensitive information that must be protected from security vulnerabilities and exploits. All organizations need to work on a continual basis to identify and remediate those vulnerabilities…
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 Import and Export MySQL Database Command line in Linux
In this article, I will show you how to import and export MySQL database command line in Linux. In this case, export is to backup while import is to restore….
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 Display MySQL root Password in Zimbra
In the situation we need to utilize the zimbra MySQL database server in order to host other databases, we may need to know what is the root password for MySQL….
How to Install phpMyAdmin on Ubuntu 14.04
phpMyAdmin is a open source software that intended to manage and administer MySQL over the Web browsers and it was written in PHP. It is one of the most popular…
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 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…
How to Install WordPress on Remote MySQL
WordPress is an open source content management system (CMS) and popular blogging platform in the world based on PHP and MySQL platform. WordPress can be install on multiple way, either…