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"
(→MySQL 4.x and 5.x) |
|||
Line 4: | Line 4: | ||
* Define a driver template for MySQL 4.1 (use this for 5.x too). | * Define a driver template for MySQL 4.1 (use this for 5.x too). | ||
+ | [Where?] | ||
* Let un == user name (for example, "root") | * Let un == user name (for example, "root") | ||
* Let pw == password | * Let pw == password | ||
− | |||
+ | Then | ||
+ | [Where?] | ||
* Jar: mysql-connector-java-5.0.0-beta-bin.jar | * Jar: mysql-connector-java-5.0.0-beta-bin.jar | ||
* Database: mysql | * Database: mysql | ||
Line 15: | Line 17: | ||
Next, create the connection profile: | Next, create the connection profile: | ||
− | + | [Where?] | |
* Choose "SQL Model-JDBC Connection" | * Choose "SQL Model-JDBC Connection" | ||
* Give the profile an appropriate name, such as "MySQL" | * Give the profile an appropriate name, such as "MySQL" | ||
Line 22: | Line 24: | ||
'''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. | ||
+ | |||
+ | Driver Definitions? | ||
+ | How to add a Driver Definition for MySQL? | ||
+ | Why can't I edit an existing Driver Definition? |
Revision as of 09:46, 30 June 2007
← 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?