[Nottingham] JDBC & CLASSPATH

[Martin Kirk]

On Monday 11 December 2006 13:34, Martin Garton wrote:
> On Mon, 2006-12-11 at 13:22 +0000, Martin Kirk wrote:
> > I'm trying to configure JDBC to work with MySQL but I'm confused.
> > I've got as far as putting the mysql-connector-java under /opt.
> > My instructions now say "modify CLASSPATH in your .bashrc file" but I
> > don't appear to have a .bashrc file.
>
> You should be able to simply create a .bashrc file in your home
> directory.  Then in it you want something like:
>
> export CLASSPATH=$CLASSPATH:/opt/path/to/mysql-connector-java.jar

Thanks Martin, I appear to be a step closer, however....

When trying to connect to MySQL via JDBC from OpenOffice I always get a 
"Connection refused" message.  I've tried various user/password combinations 
which I know are valid.

any clues ?

cheers,
Martin.