need help changing db username and password

[webmasterfm]

I originally installed CMS Made Simple with "root" and the password. I couldn't create other users at the time that worked... well now I can. I want to change the cms_user and cms_pass to the newly created ones since using root poses a security threat, right?

Where would I do this?

Thanks!

This is the best CMS by the way and I'm running IIS.

[webmasterfm]

damn... I can't get MySQL Administrator to create a user that will access the cms db... i tried changing the config.php file to the new user and password and page will not display.

That's why I ended up using root in the first place. My MySQL only like root!

The weird thing is that is I went into ODBC sources and tested a db connection I can test successfully using the new username to the cms db.... I use the ODBC just to perform as a test to see if I can connect.

I hate this problem.

[webmaster]

yes.

both manually and through mysql admin as well.

How do I add the user to the database manually?... perhaps that is my problem... I have been doing that in MySQL Admin but have not tried it by coding it.

I make changes in the MySQL Admin and the changes don't reflect. I have gone in and changed the Ns to Ys in the Query Browser and still does not work. I'm stumped.

[Ted]

It's in the INSTALL document.  GRANT ALL PRIVILEGES etc...