Skip to main content

Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Connecting to MySQL 4.x and 5.x

Revision as of 12:01, 13 July 2006 by Unnamed Poltroon (Talk)

Back to How Do I Connect to...

MySQL 4.x and 5.x

  • Define a driver template for MySQL 4.1 (use this for 5.x too).
  • Let un == user name (for example, "root")
  • Let pw == password

Then

  • Jar: mysql-connector-java-5.0.0-beta-bin.jar
  • Database: mysql
  • Driver: com.mysql.jdbc.Driver
  • URL: jdbc:mysql://localhost/?user=un&password=pw

Next, create the connection profile:

  • Choose "SQL Model-JDBC Connection"
  • Give the profile an appropriate name, such as "MySQL"
  • Choose the driver template you just created from the combo box
  • "Finish" to save the connection profile

Note that you might have to tweak these values for your case. Results in a partial tree in Data Source Explorer, and can be used with the SQL Editor.

Back to the top