Full introduction to connecting to Mysql database using Java

1. Download the mysql database Official Website: www.mysql.com to register a mysql user

MySQL For Windows V5.2 Alpha http://www.skycn.com/soft/1262.html updated on:

2. Download the mysql database driver. Address:

Http://www.mysql.com/products/connector/all drivers

Java: http://dev.mysql.com/downloads/connector/j/5.0.html

Graphic interface tool: Workshop

3. decompress the package, copy the mysql-connector-java-3.1.0-alpha-bin.jar file to your tomcat/common/lib, restart Tomcat, jsp connection mysql environment is complete.

Website approach is to release the jar file directly to the website directory \ WEB-INF \ lib

Installation references: (Package) http://hi.baidu.com/ybbucd/blog/item/5662d02a115f762fd42af1c0.html

(Installation Package) How step by step install MYSQL database http://www.zttt.net/blog/showartic.asp? Id = 474

Installation notes:

1) before installing mysql 5.0, you must uninstall the old version.

2 ). for mysql garbled characters, you also need to set the language to be selected during installation. You do not need to select gbk or gb2312 by default. when the test is successful, it will not pass the start server immediately. and so on.

3). You can download the mysql management software: EMS MySQL Manager 3 Lite.

4). My local Secutity Settins: the Default User root rootpwd: bin5812086 allows remote operations and does not allow anonymous operations

5). MYSQL Initialization

6). Start

Method 1: the system starts by default. Because the database will exist as a service after MYSQL is installed, the MYSQL database is automatically started every time the system is started.

Method 2: run the mysqladmin program in the bin directory by running the command to start the MYSQL database.

7) problems encountered after installation:

I. The database server passes the test connection on the local machine. when the machine is connected, the following error occurs: null, message from server: "Host '210. 209.142.190 'is not allowed to connect to this MySQL server "'.

Solution: In addition to setting the root password, remember to check enable acess remote connect to allow remote connection. Otherwise, only local connections are allowed.

If it is already installed, go to the \ MySQL Server 5.0 \ bindirectory, and open mysqlinstanceconfig.exe to reinitialize the settings.

1 2 Next Page

[Content navigation]
Page 1st: full introduction to connecting to Mysql database using Java	Page 2nd: full introduction to connecting to Mysql database using Java