求助：无法在Eclipse测试数据库连接，JDBC程序运行失败

Hey there, let’s walk through fixing your database connection headaches step by step—these problems are super common, and we’ll nail down what’s going wrong.

First: Verify MySQL Server & Core Configs #

• Make sure MySQL is running: On Windows, check the Services app for MySQL and start it if it’s stopped. On Linux, run sudo systemctl status mysql to check, and sudo systemctl start mysql to fire it up. For Mac, use brew services list (if you installed via Homebrew) to confirm it’s active.
• Match Workbench params exactly: You can connect via Workbench, so jot down your host (usually localhost), port (default 3306), username, password, and the exact database name you created. These need to be identical in your JDBC code and Eclipse connection settings—even a typo in the database name will break things.
• Check user permissions: In Workbench, run this query to confirm your user has access from localhost:

  SELECT user, host FROM mysql.user;
  

  If your user’s host isn’t localhost or % (allows all connections), run these commands to grant access (replace placeholders with your details):

  GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_username'@'localhost' IDENTIFIED BY 'your_password';
  FLUSH PRIVILEGES;
  

Second: Fix Your JDBC Code #

• Add the correct JDBC driver: You need the MySQL connector JAR in your project. In Eclipse, right-click your project → Build Path → Add External Archives and select the mysql-connector-java.jar file (download the version matching your MySQL server—8.0+ for MySQL 8, 5.x for older versions). If using Maven, add this to your pom.xml:

  <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.33</version> <!-- Use the latest compatible version -->
  </dependency>
  

• Check the JDBC URL format: This is a top culprit!
  • For MySQL 8.0+: jdbc:mysql://localhost:3306/your_database_name?useSSL=false&serverTimezone=UTC
  • For MySQL 5.x: jdbc:mysql://localhost:3306/your_database_name?useSSL=false
    The serverTimezone parameter is mandatory for MySQL 8—skip it and you’ll get a timezone error every time.
• Print full error details: Don’t just catch exceptions and print a generic "connection failed" message. Use e.printStackTrace() in your catch blocks to see exactly what’s wrong (e.g., missing driver, wrong password, unknown database):

  try {
      // MySQL 8+ driver class; use com.mysql.jdbc.Driver for 5.x
      Class.forName("com.mysql.cj.jdbc.Driver");
      String url = "jdbc:mysql://localhost:3306/your_db?useSSL=false&serverTimezone=UTC";
      String user = "your_username";
      String password = "your_password";
      Connection conn = DriverManager.getConnection(url, user, password);
      System.out.println("Connection successful!");
  } catch (ClassNotFoundException e) {
      e.printStackTrace(); // Tells you if the driver is missing
  } catch (SQLException e) {
      e.printStackTrace(); // Gives detailed DB error messages
  }
  

Third: Fix Eclipse’s Database Connection Test #

• Configure the driver correctly in Eclipse:
  1. Switch to the Database Development perspective (Window → Perspective → Open Perspective → Other → Database Development).
  2. In the Data Source Explorer, right-click Database Connections → New.
  3. Select MySQL, click Next, then check the Driver Class. For MySQL 8+, it should be com.mysql.cj.jdbc.Driver. If it’s missing, click Edit Driver Definition, add your JDBC JAR to the JAR List, and save.
  4. Enter your connection URL, username, password, then click Test Connection. If it fails, read the error message carefully—it’ll tell you if it’s a permission issue, wrong port, or missing database.
• Clear Eclipse caches: Sometimes old connection settings get stuck. Try restarting Eclipse, or delete the faulty connection and create a new one from scratch.

Quick Common Pitfalls to Rule Out #

• Firewall/antivirus blocking port 3306: Temporarily disable your firewall or antivirus to see if that fixes the issue. If it does, add MySQL to the allowed apps list.
• Version mismatch: Using a MySQL 5.x driver with MySQL 8.0 (or vice versa) will cause connection failures—always match the driver version to your server.
• Case sensitivity: On Linux, MySQL database names are case-sensitive. If you created MyDB in Workbench, don’t use mydb in your code.

内容的提问来源于stack exchange，提问作者nuradilla