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.
Related tutorial – MySQL
On this page, we offer quick access to a list of tutorials related to MySQL.
Tutorial MySQL – Create a Superuser account
Access the MySQL 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 MySQL account.
Grant all permissions to the new MySQL user account.
Access the MySQL command-line using the new account.
Verify the new MySQL account privileges.
Congratulations! You created a MySQL superuser account.
