1.4.3 install the mysql client Tool
When MySQL 5.1 is installed, the mysql client tool is installed at the same time to operate data in the MySQL database. However, the mysql client tool is run in the command line mode, it is not easy to use. To facilitate data operations in the MySQL database, we recommend that you install a graphical MYSQL client tool. Among the many tools, navicat is recommended.
For MySQL management tools.
1.4.3.1 download navicat
You can download navicat from the official navicat website http://navicat.com/en/download/download.html #
For MySQL tool. This course uses navicat8_mysql_cs.exe.
1.4.3.2 install navicat
Run the downloaded installation file. The page shown in 1-29 is displayed:
(Figure 1-29: navicat installation page)
Click "Next" to display the permission page. Select "I agree" and click "Next". Then, click "Next" multiple times and the page shown in Figure 1-30 is displayed:
(Figure 1-30: installation confirmation page)
On the page from figure 1-30, click "Install" to start navicat installation. After the installation is complete, click "finish" to complete the installation.
1.4.3.3. Start navicat
Start navicat from the "Start" of windows or from the desktop shortcut icon. The page shown in 1-31 is displayed:
(Figure 1-31: navicat startup Interface)
You can click "trial", or click "register" if you have a formal series number. No matter which method you use, go to the operation interface 1-32 after navicat:
(Figure 1-32: navicat operation interface)
Click "Connect" to display the interface 1-32:
(Figure 1-32: navicat connection creation page)
In the interface shown in Figure 1-32, enter a name in the "connection name" input box to indicate the database server to which the link is linked. For example, in this course, we recommend that you enter "javaweb_db_server" and enter the IP address of the MySQL database server installed in the "host name/IP Address" field, in the "password" input box, enter the password set When configuring the MySQL instance. In this course, enter "12345" and click "OK". The page shown in Figure 1-33 is displayed:
(Figure 1-33: navicat operation interface after the connection is established)
Double-click javaweb_db_server. The page shown in Figure 1-34 is displayed:
(Figure 1-34: navicat interface connected to the database server)
Now, navicat
For MySQL has been installed successfully and can be connected to the installed MySQL database server. Of course, if you do not have a navicat serial number, you can also choose other database management tools.