Mysql front installation and use tutorial

Mysql Front is a compact application tool for managing Mysql, so how can it be installed and used? L et's see.

One, mysql front-end download:

mysql front download address: Click Download

Second, mysql front-end installation

1, click on the downloaded MySQL-Front_Setup.exe program, start the installation, the following interface appears:

2, click "Next" and the following interface appears:

3, click "browse", choose to install the directory, this directory can be set according to their own needs. The example here selects an installation directory that: D: s mysql-front s MySQL-front-setup s mySQL-Front, i.e. the following interface appears:

4, and then keep clicking on the next step to know that the page below appears.

5, click on the installation, installation takes some time, after the installation will appear the following page, click to complete it.

Third, mysql front end use

When we run mysql front, we find that it's all in English, so we can set the language in the system settings and select Chinese Simplified version, as shown below:

Once the language is set, open the login information interface and enter the relevant parameters of mySQL database server:

Enter the IP address of the MYSQL server, e.g. 202.101.98.55, as shown below:

Enter the username and password of the MYSQL server, as well as the database name of mySQL, click OK, select "Open", as shown below:

If the IP, user name, password, and database of the MYSQL database are entered correctly, the server can be opened, and then the query statement of MYSQL can be copied into the SQL editor through the "view"-"SQL Editor", the MYSQL database can be quickly introduced.

MYSQL Manager's "Object Browser", "Data Browser" for the establishment and modification of database table structure and data are very convenient.