How to use navicat to create new users in MySQL database?

When deploying projects on the server, we often require each project to have a separate corresponding mysql user. We can configure it through navicat

1. First, you need to log in to a For a connection with root permissions, click "Users" to see all current Mysql users, click "New User"

##2. Then, fill in the username and password in "General". In the "Host" item, you can fill in localhost or %. Localhost means that the user only Can be accessed locally, % means that the user can access remotely or locally

##3 Add database management permissions to this user in "Permissions", taking irrigation as an example,

Note: The irrigation here is a database that has been established by the root user. Of course, the user can also be configured with the corresponding permissions to create a database in the "Server Permissions"

4. At this point we have created a new user and given the user administrative rights to the irrigation database

5. Next, perform a connection test on the created user

#

The above is the detailed content of How to use navicat to create new users in MySQL database?. For more information, please follow other related articles on the PHP Chinese website!