Heidisql is a very powerful MySQL client software that we use to operate the MySQL database, much simpler than direct command-line tool operation. We use Hidisql to connect MySQL database, the MySQL database installation can refer to the following.
- Baidu Search Heidisql's official website, click Downloads->heidisql 9.4 Installer, the official website has a Chinese version of the, after the installation of the Open Interface menu is Chinese. After downloading the file name is Heidisql_9.4.0.5125_setup.exe, right-click Install. Click on the right button to enter the installation interface, we can see Hidisql support Mysql,sql server,postgresql, click Next--Select I accept the agreement--> Select the installed directory (you can also use the default).
The following steps appear during the installation process: Create a Start menu, create a desktop shortcut, associate. SQL "files, Automatic Updates, automatic reporting of connections and version information, etc. Click Finish after clicking Install--> on the Installation page. After the installation is complete, open hidisql and go to the following page. When you click New, you can create a session by selecting create a conversation in the root category. The left side of the session name appears under the unnamed, right-select rename can be renamed, this article in the operation named localhost. On the right, enter the hostname (default native 127.0.0.1), user name (default root) and password, click "Open" button to connect. Don't forget to click on the "Save" button, the next time you connect can not enter the password. Open the interface as shown in, where test and student for themselves created libraries and tables. Heidisql anywhere can click Query directly into the inquiry editing interface, we enter the SQL statement in the query editing interface, click the "Execute" button, the results will appear below, or correct or error. The teacher table is created in the database test above, and after it is created, right-click "Refresh" on the test library and the teacher table appears. In the menu bar, click "File"-"exit" or the upper right corner of the Red Fork, pop-up prompts to save the contents of the query, select "Yes" and select the path to save the file. This article chooses to put on the desktop, the desktop appears teaacher.sql.
Heidisql Installation and Use tutorials
