Try to create a small java application to check the db connectivity Actually you need to see the exception that it throws The exception will give you idea of the problem
Once the problem is identified, you will be able to fix it accordingly Ghufran -----Original Message----- From: Abel MacAdam [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2008 4:28 PM To: [email protected] Subject: RE: Jetspeed and MySQL? Hi Ghufran, Thanks for your reply. I tried what you suggested, but no luck. I still get the "Connection to the database failed" when the installer is testing the connection. Abel ghufran-2 wrote: > > Try to give permission to the user > Run this sql > GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'; > > If you are accessing it from different computer then type your ip instead > of > localhost in the above sql > > > Hope it helps > > Regards > Ghufran > > -----Original Message----- > From: Abel MacAdam [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 17, 2008 3:58 PM > To: [email protected] > Subject: Jetspeed and MySQL? > > > Hi, > > At the moment I'm bootstrapping Jetspeed-2. After finding out I had a > corrupt installer, and finding a new one, I could start the installer. At > one moment the installer asked my to what database it should connect. I > choose MySQL (which I re-installed for Jetspeed). This is what I filled > in: > Database User Name: root > Database Password: <MyRootPassword> > JDBC Connection String: jdbc:mysql://localhost:3306/jetspeed > JDBC Driver Classname: com.mysql.jdbc.Driver > JDBC driver: > D:\lib\mysql-connector-java-5.1.6\mysql-connector-java-5.1.6-bin.jar > > As database user name I choose the same username and password as for my > MySQL installation. Is that the wise choice, or should I choose something > like: > Database User Name: <jetspeed-user> > Database Password: <MyJetspeedPassword> > > The JDBC driver is also newly installed, in the location I indicated > above. > > When the installer tests the database connection I get a "Connection to > the > database failed". What am I doing wrong? > > Abel > -- > View this message in context: > http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506023.html > Sent from the Jetspeed - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Jetspeed-and-MySQL--tp18506023p18506394.html Sent from the Jetspeed - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
