Problem with database passwords

[RyeTerrell]

I think I discovered the problem behind my two-day site outtage, and would like to ppost it here so you all wont be troubled the same way, and so that maybe some staff member will see about getting it fixed.

Okay, I THINK that if you create a new database with the same admin username as another database, even if you assign the same password, the password on the other one gets changed. For example, if you have database A, with username "bob" and password "pass", and create a NEW database, B, and apply the username "bob" and password "pass", the password for A will no longer be "pass".

The notice on the page says they will be set to whatever the password on database B was, but this turns out to be false, there is some sort of bug.

I think. :)

Rye

[dhom]

I think you're right about that problem. I had two databases with the same logins and tried removing one of the logins. The database that still had the login worked fine.

I thought, "Great! Problem solved!" So I went ahead and tried to change the SQL user name for the working database so that I could restore the non-working database with its original login name.

Now NEITHER of the databases is working. I've tried adding logins and changing my config.php file to match about ten times now, but I can't access the database that was working before.

I'm starting to think I should just migrate all of my sites to another host and start over. The never-ending list of problems here is just not worth dealing with.