admin access after upgrade

[jsmith]

I just did an upgrade from 1.4.x to latest version.  After upgrade, I can login with my username/password (which is administrator) but the admin functions don't show.  Login works, welcomes me, but the admin items are not there.  "My profile" does show and it shows that I'm a member of the 'administrators' group.  I've searched the archives and cleared cookies and temp files. I've read some threads that suggest editing the database and others that say don't do that.  Any suggestions?

[Sami]

open xxx_users table by phpmyadmin and look under user_name for your admin user and set the user_group column of that user to 1

[jsmith]

well for some reason, the database seems to have 'disappeared'.  Was fine before I upgraded... Not sure how upgrading coppermine could have done that.  The web hosting people are trying to track it down.  I guess the username/password must be stored somewhere other than the database, but the permissions are in the database.  As for content, I get the  listing of all the categories/albums but no files show up.

[jsmith]

got my database back.  now when I access my web page I get-

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'xuser'@'xx.xx.xxx.128' (using password: YES)

(username and ip changed from original message)  Guess its lost connection with database or something.  Off to search for fix...

[jsmith]

thru phpmyadmin the user is 'myuser@xx.xx.xxx.xxx'

error when I try to access my site:

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'myuser'@'yy.yy.yyy.yyy' (using password: YES)

are these ip addresses supposed to be the same?  If so, where?  The config.inc.php file doesn't have that.

[Nibbler]

You need to resolve this with your host, we can't tell you how your server is setup.

[jsmith]

ok...   thanks for the help...