I opened up another CLI to my live instance and started doing a side-by-side comparison of things — checking authentication methods, permissions, configs, anything that could cause this authentication problem.
Then I logged into MySQL and noticed that there were 2 entries in the user table for my DBUser.
REMEMBER … I know a TON about databases (not!).
It’s a duplicate! Maybe that’s the problem!?? There’s a duplicate user! Maybe it hadn’t removed the original one from the old database?? I was so happy — maybe I fixed it!? OMG … maybe that’s it!
By this point, I had rebuilt this instance or restored from a backup at least 4 times, I had had countless people looking at it and making suggestions that didn’t work, I had spent hours and hours trying to Google the error. Everything came back authentication, so the logic that it could have been a duplicate user made sense in my addled brain.
Not wanting to be rash, I quickly ask someone (also not a DB admin), “Hey, do you think it could be a problem if there’s a duplicate in this table
More Info: comptia a+ job
No comments:
Post a Comment