Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled) error

Two of my scripts just quit working on me last night and spent the rest of the night up to 1am trying to figure out whats going on.

It turned out that mysql database password never got updated when mysql was upgraded.

So a simple change in mysql database password to lengthen it and then updated the script configuration file fixed it!