Mysql Connection Error

[mgamboa]

 hi i'm newbie in this i try to use ireport in mac with sugarcrm i'm using MAMP pro with mysql and apache i download the i reports version 3.7.1 when try to make the connection this is the information i used

i don't know what i need to do

the configuration for the connection is

JDBC Driver MySQL (com.mysql.jdbc.Driver)

JDVC URL  jdbc:mysql://localhost/sugarcrm

User root

Password test

press the button to tests and show me the following error and i don't know what i need to do more please help if try to connect with phpmyadmin or mysql administrator from windows pc works perfect

 

 

 

Code:

Post Edited by mariogamboa at 03/30/2010 18:14

[mdahlman]

What happens when you connect from iReport running on Windows? (Is it a PC/Mac issue?)

The default url would be this:
jdbc:mysql://localhost:3306/sugarcrm

Does that give the same result?

Are you sure localhost is well defined there? Does using the host name give the same result?

[rajuchacha007]

try this

 

Connection conn = null;

String url = "jdbc:mysql://localhost:3306/";

String dbName = "put_your_database_name_here";

String driver = "com.mysql.jdbc.Driver";

String userName = "root";

String password = "test";

 

I hope you have defined localhost well after mdahlman's advice. Else it could be mysql issue. Just try to test with other simple connection. If it displays connected successfully then it's ok, else there is certainly issue with mysql.

[mgamboa]

sorry but where i need to write all that

[rajuchacha007]

Sorry. I believe I misunderstood your question. I was thinking to connect databse within java. Forget it. Wrong reply from my side.Apologies.

 

Best regards.