Databases

How to Install PostgreSQL on Ubuntu

March 14, 2024

PostgreSQL is an open-source, relational database management system. Follow this guide for two ways of installing PostgreSQL on Ubuntu and connecting to your database.

Read more

How to Import and Export MySQL Database

March 11, 2024

MySQL is a versatile RDBMS that can be used for anything from simple product databases to complex WordPress website. Exporting a database puts it in a dump file that can later be imported to another system. This guide will walk you through how to export the database and import it from a dump file in MySQL.

Read more

How to Install MariaDB on Ubuntu

February 28, 2024

MariaDB is an open source, fully compatible, relational database management system. It is commonly used as a replacement for MySQL due to its fault tolerance, speed, and scalability. In this tutorial, learn how to install MariaDB on Ubuntu.

Read more

How to Connect to a PostgreSQL Database from Linux or Windows

February 22, 2024

This article explores multiple ways to connect to a PostgreSQL database from Linux and Windows.

Read more

How to Fix "Access denied for user root@localhost" MySQL Error

February 13, 2024

When you install MySQL on your system, the root user may not be able to access it. Using the ALTER command, you can modify the root user and allow it access to MySQL.

Read more

Scale and Improve Database Performance Using BMC Pliops

February 8, 2024

Learn how the Pliops XDP-powered BMC instance helps scale and improve database performance. See the database and HPC boosts gained from the Pliops card and how to deploy these BMC servers.

Read more

MySQL Data Types Explained

February 5, 2024

Data types are important to understand as a name and a data type define each column in a database table. Learn all about MySQL data types and when to use them in this comprehensive guide.

Read more

How to Back Up & Restore a MySQL Database

January 25, 2024

A MySQL database has been lost, and you’re scrambling to restore a copy from your last backup. This guide shows different methods for backing up and restoring a MySQL database.

Read more

How to Connect to MySQL Database

January 18, 2024

MySQL databases are frequently employed in website building, data-driven app management, and data analysis. This article shows you how to connect to a MySQL database on Windows, macOS, and Linux.

Read more

How to Set Up MySQL Master-Slave Replication

January 16, 2024

In cloud computing, master-slave data replication refers to storing the same information on multiple servers. One server controls the group, and the other devices handle the work within the same node. This guide will walk you through how to set up master-slave replication in MySQL

Read more
1 2 3 15