Hi,
I'm having some headache on setting up the database,
and I wold like to know if you guys can help me.
I have followed by the book all the installation
procedure, but when I try to connect to the db using
the db.exe, this is the return that I got:
java.sql.SQLException: Cannot connect to MySQL server
on localhost:3306. Is ther
e a MySQL server running on the machine/port you are
trying to connect to? (java
.lang.NumberFormatException)
Fatal-Error Cannot connect to MySQL server on
localhost:3306. Is there a MySQL s
erver running on the machine/port you are trying to
connect to? (java.lang.Numbe
rFormatException)
java.lang.Exception: Stack trace
at java.lang.Thread.dumpStack(Thread.java:1071)
at jeremia.base.JEErrorHandler.printFatalError
(JEErrorHandler.java:244)
at jeremia.base.JEErrorHandler.printFatalError
(JEErrorHandler.java:155)
at jeremia.base.JEErrorHandler.fatalError
(JEErrorHandler.java:82)
at
jeremia.base.JEConnectionParameter.getConnection
(JEConnectionParamete
r.java:228)
at jeremia.base.JEDatabaseSetup.main
(JEDatabaseSetup.java:256)
I'm using the mysql DB installed on the same machine
that I have installed the jeremia software.
The connection string is the default that comes with it.
What could it be? I'm sure that is a problem with the
conectivity, but as I am not a dba, I'm a little bit lost.
Thanks for all.
Humberto Giuntoli
Logged In: YES
user_id=1077962
Just for a reminder, the mysql is up and running, and I already
have created the jeremia_db. I am able to connect via mysql
prompt.
Logged In: NO
first and foremost, i'd recommend you check your mysql connectivity via the console, by trying 'mysql -u username -p -h localhost' and see if it connects. If it connects there, then double check your mysql server settings and see what network interface/ip address it's bound to.