Useful Tips to Troubleshoot Common Errors in MySQL
MySQL is a widely used open source relational database management system (RDMS) owned by Oracle. It has over the years been the default choice for
MariaDB
Install WordPress with Nginx, MariaDB 10 and PHP 7 on Debian 9
WordPress 5 has recently been released and for those of you who are eager to test it on their own Debian server, we have prepared
How to Install MariaDB 10 on RHEL 8
MariaDB is a popular alternative to the MySQL database management system. It is developed by the original MySQL developers and is meant to remain open
How to Transfer All MySQL Databases From Old to New Server
Transferring or Migrating a MySQL/MariaDB database between servers usually takes only a few easy steps, but data transfer can take some time depending on the
How to Monitor MySQL/MariaDB Databases using Netdata on CentOS 7
Netdata is a free open source, simple and scalable, real-time system performance and health monitoring application for Unix-like systems such as Linux, FreeBSD and MacOS.
Mytop – A Useful Tool for Monitoring MySQL/MariaDB Performance in Linux
Mytop is an open source and free monitoring program for MySQL and MariaDB databases was written by Jeremy Zawodny using Perl language. It is much
How to Change Default MySQL/MariaDB Port in Linux
In this guide we’ll learn how to change the default port that MySQL/MariaDB database binds in CentOS 7 and Debian-based Linux distributions. The default port
How to Check MySQL Database Size in Linux
In this article, I will show you how to check the size of MySQL/MariaDB databases and tables via the MySQL shell. You will learn how
12 MySQL/MariaDB Security Best Practices for Linux
MySQL is the world’s most popular open source database system and MariaDB (a fork of MySQL) is the world’s fastest growing open source database system.
How to Connect to MySQL Without Root Password on Terminal
Normally while installing MySQL/MariaDB database server on Linux, it’s recommended to set a MySQL root user password to secure it, and this password is required
How to Test PHP MySQL Database Connection Using Script
MySQL is a popular database management system while PHP is a server-side scripting language suitable for web development; together with Apache or Nginx HTTP servers,
How to Change a Default MySQL/MariaDB Data Directory in Linux
After installing the components of a LAMP stack on a CentOS/RHEL 7 server, there are a couple of things you may want to do. Some