spamjim
9-1-06, 01:23 PM
This is a friendly warning for those adding MySQL databases to their account. I did a knucklehead thing that might apply to other knuckleheads...
When I added a new database, I used the same username from another one of my databases in the 'Database Login:' field. Then I set a password that was different from the password used for that user on the other database. This was not a good idea.
Powweb's MySQL DB creation function does not warn you that you are changing the password for the existing user so all of my scripts that called on the previous database died until I restored the original password.
I should have known better as I would not have done the same thing on my local installation of MySQL, but Powweb's nifty interface for creating MySQL databases made me suspend reason.
So the advice is: if you are creating a new database, create a new user name for that database as well.
When I added a new database, I used the same username from another one of my databases in the 'Database Login:' field. Then I set a password that was different from the password used for that user on the other database. This was not a good idea.
Powweb's MySQL DB creation function does not warn you that you are changing the password for the existing user so all of my scripts that called on the previous database died until I restored the original password.
I should have known better as I would not have done the same thing on my local installation of MySQL, but Powweb's nifty interface for creating MySQL databases made me suspend reason.
So the advice is: if you are creating a new database, create a new user name for that database as well.