Unable to GRANT ALL ON cacti.* or something else

[biznatch]

This is my first cacti install. When I tried to GRANT ALL ON cacti.* it told me 0 rows updated - is that a problem?

Code: Select all

mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY '**********';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

I continued on, but I am not able to authenticate. The login pages says:

Invalid User Name/Password Please Retype

What username and password am I supposed to use? I see cacti user in the user table:

Code: Select all

mysql> select user from user where user="cactiuser"
    -> ;
+-----------+
| user      |
+-----------+
| cactiuser |
+-----------+
1 row in set (0.00 sec)

A little help? Thanks.

[biznatch]

*** Update ***

I guess I was confused on how the password was set. Infact, I still am. It seems to be working now - But I'm not totally happy with a password for cactiuser/cacti. I'll keep diging to find out how to change the password.

If you happen to know how send me a link. Thanks.