[RESOLVED] trouble logging in as anything but root

[stangl]

I have upgraded my site running PHP4 to PHP6 and from Apache to IIS. We have transfered the php scripts to a new server. The MySQL database is now located on a different server whereas before MySQL was hosted locally on the same server as PHP4. The problem we're haveing now is that we can't log in to our site as any user besides the root user. I have reset all the passwords in the user table with the password function for all users and flushed priveleges but still can only login in as root. We have also tried stopping and restarting MySQL. This didn't work either. It seems the mysql_connect() function will only work for the root user.

Any ideas why this might be happening?

Thanks.

[johanafm]

The non-root users probably only have grants for 'username'@'localhost'

check USER_PRIVILEGES in the information_schema database to know for sure.

[stangl]

I figured out the problem. Thanks for your help.