急!java-mysql?

wqch

调了好久,前几天也在论坛中请教过,不过还是没有解决问题!还请各位帮忙看看!
附的图片是调试出错的报告！user和password都是正确的!
import java.sql.*;
import java.io.*;
import java.util.*;
import java.lang.*;

/**
This program tests that the database--MySQL and the JDBC
driver are correctly configured.
*/
class TestDB2
{
public static void main (String args[])
{
try
{
try{ Class.forName("com.mysql.jdbc.Driver").newInstance();}
catch(Exception e){}
String url = "jdbc:mysql://WQCH/test?user=root&password=12345678";
Connection conn = DriverManager.getConnection(url);
Statement stat = conn.createStatement();

stat.execute("CREATE TABLE Greetings (Name CHAR(20))");
stat.execute(
"INSERT INTO Greetings VALUES ('Hello, World!')");

ResultSet result
= stat.executeQuery("SELECT * FROM Greetings");
result.next();
System.out.println(result.getString(1));
result.close();

//stat.execute("DROP TABLE Greetings");

stat.close();
conn.close();
}
catch (SQLException ex)
{
while (ex != null)
{
ex.printStackTrace();
ex = ex.getNextException();
}
}
catch (Exception ex)
{
ex.printStackTrace();
}
}
}

wqch

大家帮忙啊！
谢了！

黄叶

应该是MySQL的认证问题。你最好检查一下MySQL的用户。要知道MySQL用户认证是很严格的。
可以用手动登录到MySQL中，进入mysql数据库。查看user表。
select host, user, password from user;
他细看看权限是否对了。