How to Show a List of All Databases in MySQL
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…
How to Manage MySQL Databases and Users from the Command Line
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…
How to Run Linux Commands in Background
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…
How to Create and Select MySQL Databases
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…
How to Delete a MySQL Database on Linux via Command Line
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…
How to Create MySQL Users Accounts and Grant Privileges
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…
How to Delete MySQL Users Accounts
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…
How to Change MySQL User Password
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…
How to Reset the MySQL Root Password
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…
How to Show/List Users in MySQL
Have you ever needed to get a list of all users in your MySQL server? There are commands to show databases and tables, but there is no MySQL show users…