Admin Password help

[showbiz]

Hi,
I just transferred my site to a new host and can't log in. I read your instructions on resetting but when I place

UPDATE cjoverkill_network_settings SET login='admin', passwd=PASSWORD('admin')

command into my sql window I get this error message.

MySQL said:

#1146 - Table 'showbiz_celebsite.cjoverkill_network_settings' doesn't exist

I did go into the cj-conf-inc.php file and changed the host,user,pass,db info and not sure if I should of did that?


I would appreciate any help you can give me I'm new to this.

Thank you.

[showbiz]

Problem fixed.

I had added ; to the end of the command.

UPDATE cjoverkill_settings SET login='admin', passwd=PASSWORD('admin');