2009
10.09

What does it “really” take?

Category: MySQL, Technology / Tag: , ,  / 3 comments

So I’m whipping up a quickie Perl script to dump the bodies of all functions/routines out of MySQL, each to its own file. Yes, I know I can feed a short SQL statement to the mysql client or use mysqldump to do this. I enjoy writing these short-n-sweet scripts to do this. It lets me explore and learn. So anyway, I’m testing against my local  instance using the root account when the Principle of Least Privileges creeps into my forethought. What are the fewest MySQL privileges necessary to ensure my script works properly while ensuring the least amount of damage can be caused?

Read More >>