MySQL

How to Install and Configure MySQL on a Windows Server

December 12, 2024

This article shows how to install MySQL on Windows using the MSI Installer and guides you though the configuration process.

Read more

How to Install MySQL on CentOS or Rocky Linux

December 10, 2024

This guide will walk you through installing MySQL on CentOS or Rocky Linux. MySQL is a popular free and open source database management application.

Read more

How to Install MariaDB on CentOS and Rocky Linux

November 21, 2024

In this tutorial, learn how to install MariaDB on CentOS and Rocky Linux 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.

Read more

MySQL Show User Privileges

November 6, 2024

Learn how to check permissions for a specific user in a database, review privileges for all users, and automate these tasks using stored procedures.

Read more

How to Create MySQL Database in Workbench

October 17, 2024

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.

Read more

Install and Get Started with MySQL Workbench on Ubuntu

October 10, 2024

Workbench is a visual tool for managing MySQL databases . Its graphical interface allows users to model data, build and run SQL queries, and maintain a database. Get a better understanding on how Workbench works, how to install the software and configure it for your needs.

Read more

How to List All Users in a MySQL Database

September 18, 2024

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

Read more

How to Deploy MySQL on Kubernetes

August 14, 2024

Deploying a functional database in a containerized environment can be a demanding task. This article will show you how to deploy a MySQL database instance on Kubernetes using persistent volumes, the feature that enables stateful apps to overcome the problem of the inherent transience of the K8s pods.

Read more

How to Find Duplicate Values in MySQL

July 25, 2024

Learn how to find the duplicate entries in your MySQL databases. The guide shows three different ways to find duplicates in a MySQL table.

Read more

How to Export MySQL Data to CSV

July 18, 2024

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.

Read more
1 2 3 7