MariaDB – Create a Superuser account

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.

Create a new user account.

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.

Access the MariaDB command-line using the new account.

Verify the new MariaDB account privileges.

Congratulations! You created a MariaDB superuser account.