How navicat manages remote permissions

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

Click the menu bar –> User ( Recommended tutorial: navicat tutorial)

Click to create a new user

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.

Server permission description

The above is the detailed content of How navicat manages remote permissions. For more information, please follow other related articles on the PHP Chinese website!