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.
Difference between revisions of "Connecting to MySQL 4.x and 5.x"
| Line 9: | Line 9: | ||
Then | 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 | * URL: jdbc:mysql://localhost/?user=un&password=pw | ||
Revision as of 12:01, 13 July 2006
← 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.