How to Install the Latest MySQL 8 on Debian 10
MySQL is the most widely used open-source database management system used to keep and retrieve data for a broad variety of famous applications. In Debian 10, MariaDB comes with by default as a drop-in
MySQL
How to Install MariaDB Database in Debian 10
MariaDB is an open-source and popular relational database management system (RDBMS) made by the original developers of MySQL. It is a fast, scalable and robust database system, with a rich ecosystem of storage engines,
SQL Buddy – A Web Based MySQL Administration Tool
SQL Buddy is an open source web-based tool was written in PHP language that intended to manage SQLite and MySQL administration via web browsers like Firefox, Chrome, Safari, Opera and IE+ (Internet Explorer). SQL
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 web-based applications and still remains popular in comparison to
How to Reset Root Password in MySQL 8.0
In an unfortunate event of forgetting or losing your MySQL root password, you will surely need a way to recover it somehow. What we need to know is that the password is stored in
How to Transfer All MySQL Databases From Old to New Server
Transferring or Migrating a MySQL/MariaDB database between servers usually takes only few easy steps, but data transfer can take some time depending on the volume of data you would like to transfer. In this
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. It gathers various metrics and visualizes them, allowing you
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 similar in look and feel of the most famous
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 that MySQL database server is running under Linux and
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 to determine the real size of a database file