Install and Get Started with MySQL Workbench on Ubuntu 18.04


Workbench is a visual tool for managing MySQL databases . Its graphical interface allows administrators and database architects to model data, build and run SQL queries, and maintain a database. Get a better understanding on how Workbench works, how…

Read More

How to List All Users in a MySQL Database


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 Create a New MySQL Account and Grant Privileges


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…

Read More

How To Show a List of All Databases in MySQL


With Structured Query Language (SQL), you can easily access and manage content in all your databases. This guide will show you how to list all MySQL Databases.

Read More

How to Install MariaDB 10.4 on Ubuntu 18.04


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 the latest version of…

Read More

How to Install MariaDB on CentOS 7


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…

Read More

How to Check the MySQL Version In Linux


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…

Read More

How to Connect to a PostgreSQL Database From Command Line in Linux


PostgreSQL is an open source relational database management system.In this tutorial learn how to connect to PostgreSQL from the command line using psql or pgAdmin. The GUI based pgAdmin provides a secure, user-friendly way to log in, administer, and…

Read More

How To Set Up MySQL Master Slave Replication


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…

Read More

How to Rename a MySQL database


As an administrator, you may need to rename a database. However, for security, the command to rename a database directly was removed in MySQL 5.1.23. This guide will give three alternate methods to rename a database.

Read More