Skip to main content

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.

Jump to: navigation, search

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.

Back to the top