Do you work with MySQL? I do… quite a bit.

Do you often script stuff on your server to make your life easier? I do that as well… quite a bit…

Are you including your database user account and password (or worse… your mysql instance root user account and password!) in plain-text in your script… I was doing this… and it is bad practice from a security standpoint for sure…

Okay, so if you have a bunch of scripts (and I have several for database maintenance and database backups) floating around and many of them contain your MySQL root user account credentials… that can be a real issue. There is a better way!
(more…)