kentohShutterstockMySQL is one of the most widely used database management systems worldwide. The open-source software has been available since 1995 and is considered the standard solution for relational databases. However, MariaDB is becoming an attractive alternative. We compare both systems and…
RDVectorShutterstockIf you want to back up or restore MySQL or MariaDB databases, you can use the command line to do so. This tutorial walks you through the process of importing and exporting databases—both in MySQL and MariaDB. In this dedicated article, you’ll learn how to create an empty…
Connect worldshutterstockMySQL is one of the best-known solutions in the relational database segment. But if you’re seeking a NoSQL companion to your SQL database or are aiming to get around rigid table structures altogether, it makes sense to explore NoSQL options. In this article, we’ll take a look at…
STILLFXshutterstockIt seems like almost every day a new software vulnerability is uncovered or an existing one is patched. One attack method that has long exploited such weaknesses is the SQL injection. But what exactly are these malicious database exploits, how do they work, and—most…
Understanding how to create new users and assign permissions in MySQL is essential to effectively and securely managing your databases. You can allocate different permissions to users, including permissions to view, create, edit and delete tables and entries. Find out here how…
sakkmesterkeshutterstockThe well-known open-source database MySQL is used on various platforms. When you combine MySQL with Ubuntu 20.04, you get a robust and efficient database environment for a variety of use cases, from web hosting to enterprise. In this article, we’ll show you step by step how to…
Ilya_LevchenkoshutterstockMySQL is a useful application on Ubuntu and it is a standard component in the LAMP stack. In our article, you will learn how to install MySQL on Ubuntu 22.04 step by step and configure it for your specific needs. Once the setup and settings configuration are complete, nothing…
kentohShutterstockWould you rather relational database management or a flexible NoSQL solution? When choosing the right tool for your data, it’s worth comparing MongoDB vs. MySQL. We’ll show you how the two software solutions differ from each other, what advantages and disadvantages they offer and…
RDVectorShutterstockMySQL knows several time functions. A particularly useful command is MySQL DATEDIFF. This function calculates and outputs the time between two dates. Using practical examples, we’ll show you how MySQL DATEDIFF works, how the function is structured, and what you can use it for.
kentohShutterstockYour database management system is not always kept up to date automatically. If this is the case, you should definitely perform the necessary steps manually for the sake of security. We’ll explain how you can check your MySQL version and what steps you can take to bring it up to…