install problem with mysql database

[tlyczko]

I am installing Hyperic into a server which already has mySQL installed.
I followed the instructions in the manual about setting up the user, and verified to the best of my ability within mysql that I did this correctly.
Yet at the end of installation I still get this error:

An ERROR occurred, the installation cannot continue.
FATAL EXCEPTION at /tmp/hyperic-hq-installer/installer-4.1.2/data/setup.xml:143: : The following error occurred while executing this line:
/tmp/hyperic-hq-installer/installer-4.1.2/data/setup-interactive.xml:15: org.hyperic.util.NestedRuntimeException$NestedEx: Error checking for existing database: Access denied for user 'hqadmin'@'localhost' to database 'HQ'

What can I do to fix this??

I'm quite new to this software, though not too new to Linux.

Thank you, Tom

[excowboy]

How did you test your access to the database ? Could you please send the command you are using and please provide the connection parameters you are using for HQ ?

Cheers,
Mirko

[tlyczko]

I created the user and db etc. as stated in the installation manual, then ran the install script.
Answered all the questions truthfully, then received the error message.
I used mysql to list the database, show all the users, and show all the grants.
I redid the password setting for the hqadmin user, with password hqadmin.
Took all the defaults. mysql is on the same server I'm installing to.
HTH Tom

[tlyczko]

I found the correct syntax for specifying the database; this issue went away, but now I have a new issue, about which I have posted a new question.

Thank you, Tom