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!

错误提示:1045-Accessdeniedforuser'root''localhost'(usingpassword:YES)navicat连接MySQL数据时遇到1045错误,一般是因为输入的用户名或者密码错误被拒绝访问,此时可以重置MySQL数据库的密码解决。在windows的操作步骤如下:1、找到mysql的my.ini文件,在mysqld关键字下面添加skip-grant-tables,如下图所示:该命令作用是跳过授权表

Navicat如何修改语言?下面本篇文章给大家介绍一下将Navicat Premium 的语言改成中文/英文的方法,希望对大家有所帮助!

本文介绍了如何使用 Navicat Premium 连接 MongoDB,具体步骤如下:建立连接:在 Navicat Premium 中,选择连接选项卡,并在数据库类型中选择 MongoDB。配置连接设置:输入连接名称、主机地址、端口号、用户名、密码和数据库名称。设置高级选项(可选):配置重连次数、重连间隔、SSL 加密和认证数据库。保存连接:单击保存按钮即可创建连接。

在 Navicat Premium 中连接数据库备份并还原数据:连接备份:在“连接”对话框中输入服务器信息、登录凭据,并在“数据库”字段选择备份文件。还原数据:右键单击目标数据库,选择“还原”,选择“从备份还原”并浏览备份文件。配置选项:指定覆盖数据、还原表结构等选项。开始还原:单击“开始”执行还原过程。更新连接:还原后,更新连接信息指向还原后的数据库。

使用 Navicat Premium 导入数据库文件的步骤如下:连接到目标数据库。导航到“导入向导”。选择要导入的文件。配置导入设置。开始导入。验证导入结果。

本章节为你们带来的文章是关于NavicatforMySQL软件的,你们晓得NavicatforMySQL如何连接本地MySQL数据库吗?接着,小编就为各位带来了NavicatforMySQL连接本地MySQL数据库的方法,感兴趣的用户一同来下文看看吧。进行打开电脑Navicatformysql已经安装好的,然后进行点击右上角的“连接”选项在弹出的新建连接窗口中,您可以输入连接名称,并将主机名设置为本地数据库,因此只需使用“localhost”,密码留空即可。然后方便连接的数据库是否连接成功的话,

Navicat中向表中添加数据的步骤:1. 连接数据库;2. 定位目标表;3. 打开数据编辑器;4. 添加新行;5. 输入数据;6. 提交更改(保存或按F2键)。

解决 Navicat Premium 无法运行问题的方法:确保系统符合要求,安装 Microsoft Visual C++ 可再发行组件。以管理员身份运行 Navicat Premium,禁用防病毒软件,检查防火墙设置。如果以上步骤无效,请重新安装 Navicat Premium。寻求 Navicat 支持团队的帮助。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Atom editor mac version download
The most popular open source editor

Dreamweaver Mac version
Visual web development tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),