Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Connecting to MySQL 4.x and 5.x
← 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).
[Where?]
- Let un == user name (for example, "root")
- Let pw == password
Then
[Where?]
- 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: [Where?]
- 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.
Driver Definitions? How to add a Driver Definition for MySQL? Why can't I edit an existing Driver Definition?