Navicat for mysql installation and basic usage diagram

MySQL does not have an integrated graphical interface management tool. For users, using the doc interface alone to operate mysql databases is very troublesome. Therefore, some mysql graphical management tools are commonly used, among them, navicat for mysql is the most commonly used one. (Mysql must be installed before navicat for MySQL is installed)

Download Address: https://www.navicat.com/download
It should be noted that navicat is charged, and the trial version only has a 14-day trial period.

Select the desired version to download:

Double-click the application to start installation:

Click next:

Agreement of consent:

The default path is drive C, or you can set the installation path by yourself:

Set the name in the Start menu:

Select whether to create a desktop shortcut:

Check whether the installation configuration is correct:

Installation completed:

Next we can use it.
Click the shortcut icon on the desktop to open Navicat for MySQL.
The main program interface is as follows:

Click "Connection" and select "MySQL" to open "MySQL-New Connection" to create a Connection.

 
Enter "Connection Name" and "Password", and click "Test COnnection" to create a Connection.

If the following error occurs: one possible cause is that the mysql server is not started in mysql.

Enter net start mysql in cmd to start the mysql service.

 

Enter "Connection Name", "Password", and click "Test COnnection". The "Connection Successful" dialog box is displayed. The Connection is created successfully.

 
Click OK below to create a new connection.

Create a database:

Double-click the created connection "test" to view the existing database.

Right-click the connection "test" and click New Database in the pop-up menu to create a Database.
 
Enter the database name and select the character set. Collation can be empty. Click OK to create a database.

Create a table:

Double-click the newly created database "studentmanage" to expand the database.

On the Table, right-click the Table and select New Table from the displayed menu to create the Table.

Set attributes:
 
The StudentID field (attribute) is the primary attribute, that is, "key primary ". In addition, the primary key cannot be blank and must be checked in the not null option.
Generally, the ID field is set to Auto-Increment "Auto Increment ".
Click "Add Files" to Add a field.

After entering the information, click save. The following dialog box is displayed:

 
Enter the table name and click OK to save the table.

Fill data:
Right-click the created Table "StudentInfo" and click Open Table in the pop-up menu:

The "+"/"-" below is used to add/delete a record (row), and "modified"/"X" is used to save or cancel the modification.