Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to set the operation authority of the database in Navicat, which has a certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

I. create a new user

1. Use Navicat to connect to the local server (if you have previously connected, please open the connection)

2. Click "> user" in the menu bar, as shown in the figure:

3. Click New user, as shown below:

User name: sets the user name to connect to the server

Host: sets the host ip address that is allowed to connect to the server. %, which means that this user can connect to the server on all hosts; 192.168.21.88, which means that this user can only connect to the server on the host whose ip address is in segment 21; 192.168.21.88, which means that this user can only connect to the server on the host with ip address 192.168.21.88.

Password: setting the password to connect to the server

Confirm password: consistent with password settings

II. Permission setting

As shown in the figure above, we can see that there are other Tab entries: advanced, server permissions, permissions, and SQL preview.

Advanced: you can set the maximum number of queries / updates / connections / connections and SSL per hour for this user.

Server permissions: set operation permissions for all databases on the server.

Permissions: set permissions for specific libraries and tables. When there is a conflict with the server permission setting, the server permission shall prevail.

SQL Preview: the SQL statements for all of the above settings are displayed here.

For the setting meaning of server permissions and permissions tabs, please refer to the permission description below.

III. Description of authority

IV. Experience principle of MySQL authority

Permission control is mainly for security reasons, so you need to follow the following empirical principles:

1. Grant only the minimum permissions that can meet the needs to prevent users from misoperating or intentionally sabotaging operations.

2. Limit the login host of a user when creating a user, which is generally limited to a specified IP or private network IP segment.

3. Delete users without passwords when initializing the database. When you install the database, you will automatically create some users who do not have a password by default.

4. Set a password that meets the password complexity for each user.

5. Clean up unwanted users regularly. Reclaim permissions or delete users.

Thank you for reading this article carefully. I hope it is helpful for everyone to share the contents of how to set up the operation rights of the database in Navicat. At the same time, I also hope that you can support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.