Question

jdbc连接问题不上数据库

首先是测试代码：
import java.sql.*;
import java.util.*;

public class Connect {
public static Connection GetConn() {
//String url = "jdbc:mysql://172.22.12.251/hanxu?autoReconnect=true&useUnicode=true&characterEncoding=utf8";
String url = "jdbc:mysql://localhost/hanxu?autoReconnect=true&useUnicode=true&characterEncoding=utf8&useSSL=false";
//String url = "jdbc:mysql://47.95.122.86/hanxu?autoReconnect=true&useUnicode=true&characterEncoding=utf8";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String password = "hanxu";

Connection conn = null;
PreparedStatement ps = null;
try {
Class.forName(driver);
}
catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("找不到驱动！");
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(url, user, password);
if(conn!=null){
System.out.println("connection successful");
}
}
catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println( "connection fail");
e.printStackTrace();
}
return conn;
}

public static void main(String[] args) {
Connect con=new Connect();
Connection conn = con.GetConn();
try{
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM book");}
catch(Exception e){
System.out.println(e);
}
}
}
然后是报错信息（最主要部分）：
[root@iz2ze2b0uk8w1d60w34totz test]# java Connect
connection fail
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
java.lang.NullPointerException
我这个在本地上跑是完全没有问题的，项目直接跑起。但在服务器上，在连接数据库这一关就挂了。上面的是测试代码。密码，用户都没有问题，网上的所谓的三种方式也都尝试了，求大神解决。

Answer 1

自己检查一下配置文件，名称很有可能搞错

Answer 2

丹青引赠曹霸将军(杜甫)

Answer 3

听董大弹胡笳声兼寄语弄房给事(李颀)[5]

Answer 4

白雪歌送武判官归京(岑参)

Answer 5

长恨歌(白居易)

Answer 6

感遇·江南有丹桔(张九龄)