I have forgotten my cacti admin password

[cc]

hi

if I tried :

mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'password';
ERROR 1036: Table 'user' is read only
mysql>

why this user is read only and how can I change it ?

[Lalle]

Hey Chris,

at the moment I only have limited internet access so I can't do in-depth analysis. I only remember that I had the same problem a long time ago and this was due to inproper permissons on the mysql data directory.

If I'm not mistaken this is also covered in the MySQL FAQ or documentation.

Lars

[Robert]

Hi!

I've got the same problem after and update to a new mysql-version I tried all your hints, but it still doesn't work. Any new ideas?

Thanks!

[Guest]

Unfortuantly so have I, updated to 0.8.2a from .1... Swear I havent changed the password but now it wont let me in.

I have mysql 4.0.13 running on Gentoo 1.4.

I've tried blanking the password, using md5 option and even generating an MD5 hash using cain and pasting that in

Got in after creating a new DB and installing as a new install well .. it's working now...

[mjjzr]

The suggestions above will work for Cacti 0.6.x. You can use the following SQL to reset your admin password in 0.8:

Code: Select all

update user_auth set password=MD5('NEWPASSWORD') where username='admin';

Make sure to replace NEWPASSWORD with your desired admin password. Let me know if you are still having problems logging in after running this.

-Ian

Hi
I use this one and works fine.
thanks.

[yanzur]

Check permissions on "/var/lib/php/session". I made it 777, and it worked.

Because I installed Cacti as root, a lot of things got wonky permissions.

Hope this helps.