First, mysql administrator installation
1. Download Mysql Administrator (MySQL Graphics Interface Manager)
Download the installation version under Windows from http://dev.mysql.com/downloads/, the file name is mysql-administrator-
1.0.12
-Win.zip, file size 6157kb
2. Install the software
Release the downloaded file, execute the installation file, after the download file is released, its installation file is mysql_administrator_gpl.msi
Click "NEXT" to continue
Click "I Accept the Terms in The License Agreement" and click "Next" to continue
Select the installation directory, click "Change" to modify the installation directory, click "Next" to continue
Select the installation mode, complete complete, Custom is a custom installation, click "Next" to continue
Click "Install" to continue installed
Program installation
The installer is complete, press "Finish" to exit the installer
Second, MYSQL ODBC installation
1. Download Mysql ODBC (MySQL open database connection)
From the mysql website http://dev.mysql.com/downloads / upload the installation version under Windows, the file name is myodbc-standard-
3.51.9
-win.msi, file size 2440KB, if you think it is not required, you can do it without installing.
2. Double click to run the installation file
Click "Next" to continue
Click "I Accept the license agreement", click "Next" to continue
Click "Next" to continue
Click "Next" to continue
Installation is complete, press "Finish" to exit the installer
3. Verify ODBC driver
After the installation is complete, we can see that its driver has been installed in the ODBC Data Source Manager. For verification, we can set a DSN to test it, and we can find that the driver is already installed on the mysql management monitor. .
Third, Mysql Connector / J installation
1. Download Mysql Connector / J
Download the installation version under Windows from http://dev.mysql.com/downloads/, the file is named mysql-connector-java-
3.0.15
-ga.zip, file size 1175KB;
Connector / J is an interface specification for MySQL with JDBC, which can work together with multiple third-party tools, including Apache Tomcat, JBoss, WebLogic, IBM WebSphere, etc., you can also use Eclipse, Borland JBuilder, IBM WebSphere Studio Waiting for development tools.
2. installation
First, release the downloaded file to your specified catalog, and you can choose two installation methods, one is the COM and ORG subdirectories that will release the directory, or mysql-connector-java- [version] -bin. The JAR is added to the system's classpath environment variable, and the other way is to copy mysql-connector-java- [version] -bin.jar to $ java_home / jre / lib / ext directory, pay attention to [Version] Is the version number, here I have downloaded the full file name of this file included in the file, MySQL-Connector-Java-
3.0.15
-ga-bin.jar. Now you can use com.mysql.jdbc.driver to call Mysql's JDBC management driver.
