How to manage database accounts and assign permissions

How to database account management and permission allocation, I believe that many inexperienced people are helpless about this, this article summarizes the causes and solutions of the problem, through this article I hope you can solve this problem.

In the process of using the database, we usually need to add accounts and assign administrative permissions to accounts. In the old version of HeidiSQL, account management is somewhat problematic, but this problem no longer exists after 7.0. Here we introduce how to create database management accounts and assign administrative permissions in HeidiSQL.

First click on the user icon in the navigation bar and you will see:

Since there is only one root account in our default MySQL, there is only one root account here. Let's create a user named "cit_cn", click "add" on the right, fill in "cit_cn" in "User Name", and then enter your own password, or you can use the password generated by the system.

Then we assign administrative permissions, click on the "add object" button after "Allow Access to" and select the database we want to assign permissions to:

Here you can assign the corresponding permissions to the database account:

We usually only need to assign database accounts: select,update,delete,insert,create,drop several general operation permissions.

We found it easy to manage accounts and assign permissions in HeidiSQL.

After reading the above, do you know how to manage database accounts and assign permissions? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!