Check if the current user of the DBH has permissions to create/drop procedures

if (!CheckRoutinePerms($dbh)) {
    plan skip_all =>
        "Your test user does not have ALTER_ROUTINE privileges.";
}

Check to see if the database where the test run against is of a certain minimum version

if (!MinimumVersion($dbh, '5.0')) {
    plan skip_all =>
        "You must have MySQL version 5.0 and greater for this test to run";
}