How to set database operation permissions in Navicat

In order to reduce developers' erroneous operations, permissions can be set for control. The goal is achieved by creating different users for the MySQL server and granting different permissions to the users. This article will introduce to you how to set the operating permissions of the Navicat database. Friends in need can refer to it.

The following content is the detailed setting steps.

1. Create a new user

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

2. Click on the menu bar –> User, as shown in the picture:

3. Click to create a new user, as shown in the picture below:

Username: Set the username to connect to the server

Host: Set the host IP address that is allowed to connect to the server. %, means that this user can connect to the server on all hosts; 192.168.21.*, means that this user can only connect to the server on hosts whose IP address belongs to segment 21; 192.168.21.88, means that this user can only connect to the server on IP addresses of 192.168 Connect to the server on the host of .21.88.

Password: Set the password to connect to the server

Confirm password: Keep it consistent with the password setting

2. Permission settings

Such as As shown in the picture above, we can see that there are other tab items: Advanced, Server Permissions, Permissions and SQL Preview.

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

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

Permissions: Set permissions for specific libraries and specific tables. When conflicting with server permission settings, the server permissions shall prevail.

SQL preview: All the SQL statements set above will be displayed here.

For the meaning of server permissions and permissions tab settings, please refer to the permission description below.

3. Permission Description

4. MySQL Permissions Experience Principles

Permissions Control is mainly for security reasons, so the following empirical principles need to be followed:

1. Only grant the minimum permissions that meet the needs to prevent users from misoperation or intentional sabotage operations.

2. When creating a user, limit the user’s login host, usually to a specified IP or intranet IP segment.

3. Delete users without passwords when initializing the database. After installing the database, some users will be automatically created. These users will have no passwords by default.

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

5. Regularly clean up unnecessary users. Reclaim permissions or delete users.

Conclusion

The most efficient way to learn a new knowledge is to read official documents. Most of the other learning materials on the Internet have been processed, and processed in a bad direction. Otherwise, people follow what others say and lead people astray. However, many times I have to learn from the Internet, because most of the official documents are in English, which is really difficult to read. At this time, I discovered that being able to read English documents easily is a very valuable skill.

The above is the detailed content of How to set database operation permissions in Navicat. For more information, please follow other related articles on the PHP Chinese website!