Java Database Connectivity (JDBC)

I am trying to get it so that I can use JSP and servlets to connect to a mysql database on my server. It is a new dedicated machine, so I am a bit new to the whole admin thing, but I do have Perl and ASP (Chillisoft) all connecting to the DB that I am trying to use JSP with, without any problems. So I don't think that the database itself is the problem (permissions, that kind of thing).

This is the message that I get:

SQLException: Cannot connect to MySQL server on 127.0.0.1:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException) SQLState: 08S01 VendorError: 0


I have spend the last 2 or so days searching the web, reading posts and such, and have not made much headway.

Right now, my biggest question is, have I installed the driver right, for sure?

At first, I did not have it installed right, and that was giving me some problems. But now I have it in the classpath, and everything seems to be correct. But could that have something to do with the error that I am getting?

If the driver was not working at all, would't I just get a "Can't find correct driver" message?

Anyway, I am running a cobalt, with Linux, a new version of MySQL, and java 1.3, and the MM MySQL driver, version 2.0.2.

I am new to JDBC, so forgive me if I am just missing something huge.

Thanks so much for any suggestions.

-Zach