Navicat 8 Create a database and create a user-assigned permission graphic method _mysql

Here is a way we need to create a data and a user, the principle of graphic operation is the same as the command line principle.

Navicat 8 Compact version (7M) MySQL image management tool V8.0.28

The first step, the first connection to MySQL if there is no connection, the MySQL database is generally not started, or the password is incorrect. We can work it out.

Second step, first create a database jb51



The third step: input jb51, the following is the default character, under normal circumstances GBK default can be. If the UTF8 is the best choice for the corresponding characters, to prevent the occurrence of garbled.

Fourth step: Create a new user Jb51user, first click the management user, click Add User
Fifth step: New users, click to expand to see more than one database, you can choose the database we created above jb51, here to bbsjb51 as an example, the main is to see the special permission of the database, general election can be, if for security, you can set more detailed permissions. For example: select only.