MySQL

The article provides many images that guide you through each individual step of a MySQL installation on Windows. The elaborate setup is made easy with clear instructions and concise descriptions of each particular option.

This article explores several highly efficient methods that allow you to export a MySQL table as a CSV file. As a CSV file, the data from your tables becomes much more accessible, both to humans and a host of other applications.

Learn how to find the duplicate entries in your MySQL databases. The guide shows you how to use the GROUP BY, COUNT() HAVING, and INNER JOIN functions to locate the duplicate entries.

MySQL, the most widely used relational database management system can be installed on CentOS 8 from the default AppStream repository or from the official MySQL developer's repository. This article details both options and instructs how to secure your databases.

Deploying MySQL in a container is a fast and efficient solution for small and medium-size applications. Instead of setting up a separate MySQL server, you can deploy a MySQL database container instead. These containers are lightweight and fast to spin up since they share the kernel and libraries of the host while packaging the deployed application.

Workbench is a cross-platform, open-source, visual tool for database management. It provides a user-friendly GUI in which you can create and maintain databases. Learn how to create a MySQL database and table in Workbench, as well as how to add data to a table.

This simple tutorial analyses the commands used to list all user accounts in MySQL. Learn about additional options that help you focus your search.

MySQL is a database application for Linux. It’s part of the LAMP (Linux, Apache, MySQL, PHP) stack that powers many features on the internet. A MySQL installation starts by default with a root user, but it’s better to create a specific user account that’s non-root.

For CentOS 7 users, MariaDB is the default database system as it replaced MySQL as the default database system. In this tutorial, learn how to install MariaDB on CentOS 7 from the local repository or official repository. The guide also shows you how to secure MariaDB and connect to the database management system from the command line.

It is essential to know which version of MySQL you have installed. The version number helps to determine if a specific feature is available or compatible with your system. This article provides five options to check your version of MySQL in Linux Operating Systems.