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 instead of MariaDB
By default, CentOS 7, RHEL 7, and Oracle Linux 7 come with MariaDB, a drop-in replacement for MySQL. However, in some cases, you might prefer to use the original MySQL…
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
Monitoring the size of your MySQL or MariaDB databases is crucial for optimizing database performance, managing storage capacity, and planning for future growth. In this short guide, we will show…
How to Change the WordPress URLs in MySQL Database
In WordPress, the URLs of your website are stored in the MySQL database. If you need to change the URLs of your WordPress site, whether due to a domain change…
How to Import and Export MySQL Database Command line in Linux
MySQL is a widely-used open-source relational database management system. Importing and exporting MySQL databases are common tasks when managing or migrating data between servers or applications. In this guide, we…
How to Secure MySQL Server on CentOS 6.5 / CentOS 6.6
MySQL, the world’s most popular open source database and the second most widely used open-source relational database management system (RDBMS), is a crucial component of many web applications. However, its…
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 an open-source software tool, written in PHP, designed to manage and administer MySQL databases via web browsers. It is one of the most widely used tools for managing…
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 MySQL Processes
MySQL is a popular open-source relational database management system (RDBMS) used by developers and administrators to manage, store, and retrieve data in a structured format. When working with MySQL, it’s…