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.
Connecting to MySQL 4.x and 5.x
Revision as of 11:50, 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.