When administering MySQL database servers, one of the most common tasks you’ll have to do is to get familiar with the environment. This involves tasks such as listing databases that reside on…

MySQL is the most popular open-source relational database management system. MySQL server allows us to create numerous users and databases and grant appropriate privileges so that the users can access…

Typically when you run a command in the terminal, you have to wait until the command finishes before you can enter another one. This is called running the command in…

MySQL is the most popular open-source relational database management system. This tutorial explains how to create MySQL or MariaDB databases through the command line. Before you begin We are assuming that…

MySQL is the most popular open-source relational database management system. This tutorial describes how to delete (or drop) a MySQL or MariaDB database through the command line. Before you begin All…

MySQL is the most popular open-source relational database management system. MySQL server allows us to create numerous user accounts and grant appropriate privileges so that the users can access and…

MySQL allows you to create multiple user accounts and grant appropriate privileges so that the users can connect and manage databases. If the user account is no longer needed, it is a…

In this tutorial, we will show you how to change MySQL user passwords. The instructions should work with any modern Linux distribution such as Ubuntu 18.04 and CentOS 7. Prerequisites…

Have you forgotten your MySQL root password? Don’t worry, it happens to all of us. In this article, we will show you how to reset the MySQL root password from…