Test::mysqld automatically setups a mysqld instance in a temporary directory, and destroys it when the perl script exits.