Problem in creation of MySQL Database Instance

[ThiagoDias]

Hi there,

I'm totatly new in Hyperic and I'm implementing Hyperic here in our company.
When creating the DB instance, the follow occurs in the last command, to grant access right:

--------------
mysql> create user 'hqadmin'@'localhost' identified by 'nt2000xp';
Query OK, 0 rows affected (0.02 sec)

mysql> create database HQ;
Query OK, 1 row affected (0.00 sec)

mysql> grant all HQ.* to 'hqadmin'@'localhost';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual thatcorresponds to your MySQL server version for the right syntax to use near 'HQ.* to 'hqadmin'@'localhost'' at line 1
-------------

May be my fault, or not?

Thank you,

Thiago Dias.

[admin · Accepted solution]

Looks like you are missing the ON keyword:

grant all on HQ.* to 'hqadmin'@'localhost';

Also, I assume that you have already created the HQ database?

Charles

[ThiagoDias]

Thank you clee,

In Hyperic documentation I wasn't in view the ON operator. Now I'll continue to implement the MySQL for Hyperic.

Regards,

Thiago.

[admin]

Just to make sure that our documentation is correct. Can you point me to the documentation page that does not specify the ON operator? I'll make sure that we correct it. Thanks.

Charles