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]
