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 13: | Line 13: | ||
* driver: com.mysql.jdbc.Driver | * driver: com.mysql.jdbc.Driver | ||
* URL: jdbc:mysql://localhost/?user=un&password=pw | * 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. | '''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. |
Revision as of 11:50, 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.