Would you like to learn how to create a MariaDB 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 20.04
• Ubuntu 19.04
• Ubuntu 18.04
• MariaDB 10.3

Tutorial MariaDB - Create a Superuser account

Access the MariaDB 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 MariaDB account.

Grant all permissions to the new MariaDB user account.

Copy to Clipboard

Access the MariaDB command-line using the new account.

Copy to Clipboard

Verify the new MariaDB account privileges.

Copy to Clipboard

Congratulations! You created a MariaDB superuser account.