EE Only

To connect to a MySQL SLED database, perform the following steps.

  1. Switch to the SLED perspective. To do this, select Window > Open perspective > Other ... > SLED from the menu bar.
  2. Click on the New... button in the toolbar of the Connections view.
    New MySQL Connection
  3. Select entry MySQL from the list of availables connection profile types.
    MySQL Connection Profile
  4. Enter a name for your new connection profile e.g. MySQL .
  5. Enter an optional description for your new connection profile e.g. MySQL@localhost.
  6. Press the Next button
  7. Press the following button to define a new driver definition.
    New Driver Definition
  8. Select the required MySQL driver template from the list of available templates.
    Select MySQL Driver
  9. Switch to the JAR List tab.
  10. Remove the listed driver, if you receive an error message by selecting it and then press the button Remove JAR/Zip . To add a new correct driver, press the button Add JAR/Zip... and select a valid JAR file which is consistent with the selected MySQL version.
  11. Switch to the Properties tab.
  12. Correct the entry in the Connection URL, so that it points to your MySQL database location, e.g. jdbc:mysql://localhost:3306/fpm .
  13. Correct the entry in the Database name field, e.g. fpm .
  14. Enter a valid Password and User ID for your Database.
  15. Press the OK button.
  16. Press the Test Connection button to validate your settings. If you receive a message like Ping succeeded! you can press the Finish button to confirm your selections.

A new entry with for your SLED Derby Database will be added to the Connection view.

New MySQL Connection Profile