Would you like to learn how to create a MySQL superuser account? In this tutorial, we are going to show you how to create a new user account and configure the same permission as the ROOT account on a computer running Ubuntu Linux.

• Ubuntu 18.04
• Ubuntu 19.04
• MySQL 8.0.19

Equipment list

The following section presents the list of equipment used to create this tutorial.

As an Amazon Associate, I earn from qualifying purchases.

Tutorial MySQL - Create a Superuser account

Access the MySQL command-line.

Copy to Clipboard

Create a new user account.

Copy to Clipboard

In our example, we create a user account named SUPERUSER.

In our example, the password kamisma123 was set to the new MySQL account.

Grant all permissions to the new MySQL user account.

Copy to Clipboard

Access the MySQL command-line using the new account.

Copy to Clipboard

Verify the new MySQL account privileges.

Copy to Clipboard

Congratulations! You created a MySQL superuser account.