mysql root password change

Hi there,

we've just accuaired manageengine. First thing I did after I isntallation was the MYSQL root password change (it's blank by default). I opened the console from the web interface and executed the follwing statement "UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'" - this succesfully changed password and I can get with MySQL amdinistator on to the databse just fine. The web interface stoped working though. I assume that the password can be chaged somewhere in config files so it'll start working again.

Can you please let me know where shall I specify the new password in ordert to fix it? Can you also let me know what's the proper procedure for changing this password.

Cheers