Databases

Keep your database servers separate from your public-facing web servers to improve security, performance, and flexibility. MySQL servers are initially set up to accept local connections. Use this tutorial to change these settings in the MySQL configuration file and enable remote connections.

Once you install MariaDB, one of the first things you need to do is to create a new MariaDB user. This article explains how to create a MariaDB user, and then how to grant privileges to the newly created user.

Learn how to export a PostgreSQL table to a .csv file. This feature is especially helpful when transferring the table to a different system or importing it to another database application. The guide shows you how to use either the COPY or the /copy command to export PostgreSQL databases and columns as .csv files.

Save time and effort by managing different database systems with a single tool. Find out how to set up SQL Workbench to connect to a PostgreSQL database with four (4) easy steps. Use SQL Workbench to migrate data between your databases without the need to use several concurring interfaces.

When adding data to a MySQL database, you may end up with duplicate rows. This article shows you how to find these instances and delete duplicate rows in MySQL. Create a test database, add data to it and practice identifying and removing duplicate rows.

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.

This tutorial shows you how to use Docker and an official MongoDB container image to deploy your databases. Additionally, it covers basic commands that allow you to interact with the MongoDB client effectively.

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.