Install MySQL on Debian 10

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

Install MariaDB Database in Debian 10

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,

Sqlbuddy - MySQL Administration Tool

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

Troubleshoot Errors in MySQL

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

Reset Root Password in MySQL 8

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

Change MySQL Port in CentOS and Ubuntu

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

Check MySQL Database Size in Linux

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