MacBook下MySQL(MariaDB)启动失败及Eclipse连接问题求助

Hey there, let's work through this step by step—no need to stress, we'll get your MariaDB back up and running and connected to Eclipse properly. Here's what to do:

1. Stop Any Residual MariaDB/MySQL Processes First #

First, let's make sure there are no stuck processes that might be blocking a clean restart:

• Open your Terminal and run:

  mysql.server stop
  

If you get an error like ERROR! MySQL server PID file could not be found!, don't worry—that just means no active server was running, and we can move on.

2. Uninstall the Accidentally Installed MariaDB 10.2 Server #

It sounds like you downloaded the full MariaDB 10.2 server package instead of just the JDBC driver jar. This is likely causing conflicts with your existing setup. Let's clean that up:

• If you used Homebrew to install it (common on Macs), run:

  brew uninstall mariadb@10.2
  

• Next, remove any leftover files that might cause issues:
  • Important: If you have existing database data you want to keep, back up the /usr/local/var/mysql directory first!
  • Delete the data directory:

    rm -rf /usr/local/var/mysql
    

  • Remove any leftover configuration files:

    rm -f /usr/local/etc/my.cnf
    

3. Reinstall and Start a Stable MariaDB Server #

Since you were able to start MariaDB before, let's get a working server back up:

• Install the latest stable MariaDB version via Homebrew (or a version you know works for you):

  brew install mariadb
  

• Start the service using Homebrew's service manager (more reliable than mysql.server start):

  brew services start mariadb
  

• Verify the server is running by logging into the MariaDB command line:

  mysql -u root
  

If you see the MariaDB [(none)]> prompt, your server is good to go!

4. Grab the Correct MariaDB JDBC Driver Jar #

You need the MariaDB Java Client (JDBC driver), not the server package. Here's how to get it set up in Eclipse:

• Download the mariadb-java-client-2.2.x.jar (e.g., 2.2.6) from the official MariaDB resources (look for the JDBC Driver section, not Server downloads).
• In Eclipse, right-click your project → Build Path → Add External Archives...
• Select the downloaded jar file to add it to your project's classpath.
• Note: If your project uses Maven or Gradle, you can also add the driver dependency directly in your build file instead of manually adding the jar.

5. Test the Eclipse to MariaDB Connection #

Let's confirm the connection works:

• Open the Database Development view in Eclipse: Window → Show View → Other → Database → Database Connections
• Click the New button to create a connection profile:
  • Select MariaDB as the database type
  • Point to the JDBC driver jar you added earlier
  • Fill in your connection details:
    • Host: localhost
    • Port: 3306
    • Database name: Create a test database first in the MariaDB command line with CREATE DATABASE test_db;, then use test_db here
    • Username: root
    • Password: Leave blank if you haven't set one, or enter your root password
• Click Test Connection—if it succeeds, you're all set!

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