Running out of hairs to pull out - Powweb mySQL password corruption!

[EvilCensor]

Okay, I'm having a troublesome time speaking to someone that can help.

livechat and even calling tech support remedy the symptom but not the cause.

I have several mySQL databases and occasionally they all stop responding to my websites - these databases are accessed by various forum scripts so that in itself would make the scripts to be less likely at fault.

One reply I received to my tickets informed me of one character being incorrect in my password - somehow they are becomming corrupted.

Then today all sites were working fine - I create a new database (which works fine) and discover immediately that all my other databases are not accessible.. so it seems that by creating a new database my previous database passwords are becomming corrupted.

I can't seem to speak with anyone that gets the gist of this - they only want to revert to backups of my database.. someone please advise :(

[entrecon]

Are you using the same username for your databases? I found that if I used the same username, even on a differnt database, MySQL would get confused.

[EvilCensor]

No, different passwords.

[Dbrazzell]

hmm this is an unusual issue. Mysql stores the passwords in its own internal format on the server which is very reliable. The only other place that password is stored is in the php scripts that access the database. It seems unusual for something to be able to come along and change that password.


Does changing the password back to what it was or something different solve the issue for you?

[EvilCensor]

When the guys at tech support "do their thing" it comes back.. but like I said all my sites were working fine, then I simply added another database and found all my other sites could no longer connect to their respective databases - yet the new one could.

I had not altered anything.

[EvilCensor]

Okay manually changed password in the ops mySQL management tool to match that in the config.php - and guess what it works.. so somehow it would *seem* that the password is being corrupted/altered as I said.

[IanS]

To EvilCensor>>
Are you using the same username for your databases? I found that if I used the same username, even on a differnt database, MySQL would get confused.

You replied:
No, different passwords

What about the usernames (in different mysql databases), not just the passwords?

[EvilCensor]

Some of the database share the same username.

[IanS]

Some of the database share the same username.
That, from what Entrecon said, maybe part of the problem. Try usernames with a code in front to distinguish them.

[EvilCensor]

Okay, I'll do that from now on.. hope to see back of this issue.

Thanks all.