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

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"

#

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!