Netbeans和mysql通信(Netbeans and mysql communication)

 我为我们公司创建了一个应用程序。 起初，我试图在我的MySQL-xampp数据库中创建没有密码，它工作正常。 现在我的问题是我在我的数据库上放了一个密码，我的应用程序现在每次登录时都会抛出这个错误： 
 
 
 
 SQL java.sql.SQLException：对用户'root'@'CITSP-MOB7'的访问被拒绝（使用密码：YES） 
 
 
 连接我的数据库时出错： 
 
 
 
 无法连接。 无法使用com.mysql.jdbc.Driver建立与jdbc：mysql // localhost：3306 / mydb的连接（对用户'root'@'CITSP-MOB7'（使用密码：YES）拒绝访问）。 
 
 
 这是我的数据库连接代码： 
 
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://192.168.1.112:3306/citsp";
static final String USER = "root";
static final String PASS = "mypassword";

try{
   Class.forName("com.mysql.jdbc.Driver");
  }catch(ClassNotFoundException ex){
            }
  //STEP 3: Open a connection
  System.out.println("Connecting to database...");
  conn = DriverManager.getConnection(DB_URL,USER,PASS);

  //STEP 4: Execute a query
  System.out.println("Creating statement...");
  stmt = conn.createStatement();
 
 有人可以帮我解决我的连接问题吗？ 您的回答将不胜感激。 提前致谢！ :) 

I've created an application for our company. At first, I've tried to create without password on my database in MySQL-xampp and it works fine. Now my problem is I put a password on my database and my application is now throwing me this error whenever I log in:
 
 
 
SQL java.sql.SQLException: Access denied for user 'root'@'CITSP-MOB7'(using password: YES)
 
 
I also get an error connecting my database:
 
 
 
Unable to connect. Cannot establish a connection to jdbc:mysql//localhost:3306/mydb using com.mysql.jdbc.Driver (Access denied for user 'root'@'CITSP-MOB7' (using password: YES)).
 
 
Here is my code for database connection:
 
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://192.168.1.112:3306/citsp";
static final String USER = "root";
static final String PASS = "mypassword";

try{
   Class.forName("com.mysql.jdbc.Driver");
  }catch(ClassNotFoundException ex){
            }
  //STEP 3: Open a connection
  System.out.println("Connecting to database...");
  conn = DriverManager.getConnection(DB_URL,USER,PASS);

  //STEP 4: Execute a query
  System.out.println("Creating statement...");
  stmt = conn.createStatement();
 
Can somebody help me to solve my connection problem? Your answer will be appreciated. Thanks in advance! :)

原文：https://stackoverflow.com/questions/29787434