Use navicat8 to create databases and import data to manage users and permissions [_ MySQL

Use navicat8 to create databases and import data to manage users and permissions [graphic method] Navicat

BitsCN.com

The following figure shows how to use this tool to create a database and import data. Navicat 8

1

2

3

4

5

6

7

8

9

10

11

12. The tutorial is complete.

2. Manage user establishment and assign user permissions

Here, we can find that root is the user with the highest level of MySQL permissions. it has the permission to view, modify, and delete all databases in MySQL software. When multiple databases are required and assigned to different users, multiple users only have the permission to view their own databases and do not interfere with each other, what should they do? The answer is simple: create multiple databases and users, and grant users the permission to manage specified databases. The procedure is as follows:

Right-click "localhost_3306" and select "create database", for example:

Enter the name of the database you want to name in "type database name", such as xunmei, "character set", and "sorting", which remain unchanged by default. click "OK ".

Click "Manage users" at the top, for example:

In the pop-up "add user" window, enter the user name you want to set in "user name", for example, xmuser. Enter localhost, password, and confirm password in "host", enter the password you want to set, for example, xunmei123, and click "OK ".

Click the plus sign on the left of the user just created. expand to view multiple databases. Click the database xunmei you just created, click "select all" on the right, and then click "save ". In this case, the xunmei database has a yellow lock icon, indicating that the xmuser has the permission to manage the xunmei database. For example:

The setting is complete. To verify whether our settings are correct, we can use the user xmuser and password xunmei123 just created to connect to the localhost host address. After the connection, we found that the user can only view the xunmei database and the temporary information_schema Virtual Database. This proves that the previous settings are correct and the tutorial is complete.

BitsCN.com