I need to be able to load csv's into my db. Currently when you try to run

SET GLOBAL local_infile=1;

you get

Error Code: 1227. Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

This is another good explanation of the problem: