Did you create the database called Jetspeed with access rights for root?
You are trying to connect to jetspeed so it should be there.
Otherwise, your string looks good.
I would not use root for the database user just in case you ever want to
put this into a production environment.
Might as well start with a Jetspeed user that can work with more limited
powers.
For screwing about on your own machine it doesn't matter.
Ron
Abel MacAdam wrote:
I looked up an easy application, added a JDBC jar file, compiled it and ran
it. It works as expected.P-( So no exception that can enlighten me.
ghufran-2 wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
