[opencms-dev] error connecting to mysql during setup

[Ivan Biddles]

Hi Todd,

I has the exact problem as you on almost the identical configuration
components.

What finally solved it was granting privileges to localhost, via:

   bash-2.05b$ mysql -u root -p<password>
   mysql> use mysql
   Database changed
   mysql> grant all privileges on *.* to root at 127.0.0.1
       -> identified by '<password>' with grant option;

Hope this helps.

    Ivan

-----Original Message-----
From: owner-opencms-dev at www.opencms.org
[mailto:owner-opencms-dev at www.opencms.org] On Behalf Of Kenneth
Lewelling
Sent: Thursday, December 12, 2002 19:16
To: opencms-dev at www.opencms.org
Subject: RE: [opencms-dev] error connecting to mysql during setup

Todd, when you checked the username/pass for mysql did you
check on the machine you are running tomcat on (looks like myslq
is running on the same host as tomcat)? In mysql its been my experiense
you have to create two accounts if you want to connect localy and
remotely
from the same username/pass.

Kenneth

-----Original Message-----
From: owner-opencms-dev at www.opencms.org
[mailto:owner-opencms-dev at www.opencms.org]On Behalf Of Todd Jones
Sent: Thursday, December 12, 2002 9:16 PM
To: opencms-dev at opencms.com
Subject: [opencms-dev] error connecting to mysql during setup


I am using RedHat7.3 stock with the following components.
        Sun SDK 1.4.1
        OpenCMS 5.0 Beta 2
        MySQL 3.23.49-3
        Tomcat 4.12 (rpm)

I have installed the opencms webapp, but with some difficulty.  Tomcat
would
not unpack the war.  So, I unpacked it manually and restarted tomcat.
Everything appears okay at this point.  I can access the sample servlets
and
jsp's from Tomcat.

I can go to the setup page, but when I place my mysql username and
password
in
the form and press continue, I receive the following error.

Could no connect to database via: jdbc:mysql://localhost:3306/
java.sql.SQLException: Invalid authorization specification: Access
denied
for
user: 'root at localhost.localdomain' (Using password: YES)

-------------------------------------------
java.lang.NullPointerException

-------------------------------------------

I have verified I can connect to mysql using the username/password I
placed
into the form using the monitor.

Does anybody know the possible problem?  Do I need any extra software?

I could not find any help in the archive or on the website.

I appreciate your help in this matter.

Regards,

Todd Jones