Corrupted Tables in MySQL featured image

Quick Solutions to Repair Corrupted Tables in MySQL: A Tutorial

MySQL is one of the most popular open-source RDBMS (Relational Database Management Systems). It is an integral part of the rapidly growing LAMP Stack and has gained impressive fandom among developers and system admins. Compared to non-relational databases, SQL provides excellent functionalities to arrange, store, and manage data effectively. The distinguishing table arrangement functionalities and stand-out capabilities of the SQL …

Node.js Application featured image

Connecting PostgreSQL with Node.js Applications: A Tutorial

When it comes to database management, PostgreSQL is one of the most popular open-source programs used all across the board. The CloudSigma PaaS allows you to install either a standalone or clustered PostgreSQL database for your application. Furthermore, CloudSigma PaaS makes connection configuration and scaling an absolute breeze. So how can you go about connecting your Node.js application to a …

Root Password reset featured image

How to Reset MariaDB or MySQL Root Password

MySQL is one of the most popular database systems out there. It’s an open-source relational database management system that follows a client-server model. MySQL is at the core of many of the online services we enjoy on a regular basis. MariaDB is a community-developed fork of MySQL that enjoys commercial support. In the MySQL ecosystem, root is the default user …

Relational Database Management Systems Compared featured image

SQLite vs MySQL vs. PostgreSQL: Relational Database Management Systems Compared

Introduction Database management tools are mostly used by the relational data model. This model organizes data into tables consisting of columns and rows. While this model remains dominant in terms of storing and managing worldwide data, there are other data models such as NoSQL and NewSQL out there. In this tutorial we will delve into three of the most widely …

How-To-Install-and-Use-PostgreSQL-on-Ubuntu-18.04

Setting up PostgreSQL on an Ubuntu 18.04 Server

As time and technology continue to progress, the internet holds a central position in the modern world. That is why most companies and businesses have websites and applications to represent the online aspect of their brands. Regardless of whether you are the owner of a small or large website, you need the help of certain tools to make your job …

MySQL basics

MySQL User – Create and Grant Permissions

In this CloudSigma tutorial, you will learn how to create a MySQL user, grant various permissions and privileges, and delete it. MySQL is an open-source Relational Database Management System (RDBMS) that helps users to store, organize, and manage the data. It is very popular and widely used in the IT industry. Learn how to setup MySQL on a server, and …

MySQL basics

How to setup MySQL on a server and MySQL basics

In this CloudSigma tutorial, you will learn how to setup MySQL on a server, and the MySQL basics. MySQL is an open-source Relational Database Management System (RDBMS) that helps users store, organize, and manage data. It is very popular and widely used in the IT industry. Creating the machine First, you have to create a machine. You can do that …