smithproject.org

Hello,

I'd appreciate it if someone could walk me through installing the mysql driver connector so I maybe able to connect to a remote database.

What I've done sofar:
-downloaded the mysql JDBC driver(lots of files in zip format)
- installed/running smith/cf on a my thumb drive.

Any help appreciated.

Thx,

Zack

Download the Source and Binaries (zip) file from http://dev.mysql.com/downloads/connector/j/5.0.html

You only need one file from this .zip: mysql-connector-java-5.0.8-bin.jar

Put mysql-connector-java-5.0.8-bin.jar in your Smith \lib directory, then restart Smith.

In the Smith Administrator, on the Data Sources page, fill in the following fields:

name: mysql

JDBC URL: jdbc:mysql://mySystem/myDatabase (substitute the remote MySQL computer name for mySystem and your database name for myDatabase)

JDBC Driver full class name: com.mysql.jdbc.Driver

Username: your MySQL username

Password: your MySQL password
... then click on the [Save data source] button.

Be careful about upper and lower case - most of these fields are case-sensitive.

After you do this, you can click on the [Val] button next to the mysql datasource to test if it is set up correctly and can access your database.
A green check mark indicates that all is OK. If you get a red X instead, click on the red X to see the cause of the error.

-tom-