用jdbc连接不上Mysql 呢？着急啊！

kider

与版本也有关系，权限认证机制不一样，4.1的用4.1的驱动(21位)，4.0的用4.0的驱动（16位）

review

奇怪了，用php就能连接上，用jdbc就是连接不上 找解决办法中
<?php
        #connect to server and select databse
        $conn=mysql_connect("localhost","root","" or die(mysql_error());
        mysql_select_db("mydatabase",$conn) or die(mysql_error());
?>

review

我再试

review

http://dev.mysql.com/downloads/  上只有这几种版本的能下载啊！麻烦kider详细告诉我4.1版本的jdbc驱动应该去哪里找，好吗？我先谢了，思考中...嗯

MySQL Connector/J -- for connecting to MySQL from Java
MySQL Connector/J 3.1 -- Generally Available (GA) release (recommended)
MySQL Connector/J 3.0 -- Generally Available (GA) release
MySQL Connector/J 3.2 -- development release
Older releases -- older releases (only recommended for special needs)
Snapshots -- sour

show90

java.sql.SQLException: Cannot connect to MySQL server on localhost:3306.你连的是localhost但你的MYSQL运行在IP地址上,你把localhost改为IP地址就OK了

review

改成IP依然不灵
错误信息
java.sql.SQLException: Cannot connect to MySQL server on 192.168.8.56:3306. Is t
here a MySQL server running on the machine/port you are trying to connect to? (j
ava.lang.NumberFormatException)


用cmd能连接上的

C:\>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.8-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

review

大家看看我的my.ini有什么不对劲的地方吗？


#This File was made using the WinMySQLAdmin 1.4 Tool
#2005-1-6 21:00:06

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=D:/mysql-4.1.8-win
#bind-address=192.168.8.56
datadir=D:/mysql-4.1.8-win/data
default-character-set=gbk


#language=D:/mysql-4.1.8-win/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
#Port number to use for connections.
port=3306

[client]
default-character-set=gbk

[WinMySQLadmin]
Server=D:/mysql-4.1.8-win/bin/mysqld-nt.exe
user=admin
password=1234

review

http://www.photodump.com/viewer/cnperl/mysql.html

review

哎，虽然失望，但让在研究中，嗯

nora_tt2000

<%@page contentType="text/html;charset=gb2312"%>
<%
//声名
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
//regiester jdbc driver


String DBUser="d12345";
String DBPassword="12345678";
String DBServer="s509.************"; // Can't use localhost , you must use IP or CNAME
String DBNAME="db_abc_com"; // change to your db name

Class.forName("org.gjt.mm.mysql.Driver".newInstance();
//connect to the database
sqlConn=java.sql.DriverManager.getConnection
("jdbc:mysql://"+DBServer+":3306/"+DBNAME+"?useUnicode=true&characterEncoding=gb2312", DBUser,DBPassword);