This restriction can be removed from MySQL Workbench 8.0 in the following way. Edit the connection, on the Connection tab, go to the 'Advanced' sub-tab, and in the 'Others:' box add the line 'OPT_LOCAL_INFILE=1'.

Quoted from this link and big_water: https://bugs.mysql.com/bug.php?id=91872

This did work for me in MySQL workbench 8.0, but I felt that this answer was not specific enough. I struggled to find the connection tab.

From an opened connection, select the 'server' drop down menu, then select 'Management Access Settings...' near the bottom of the menu. This will bring you to the connection tab.

For additional information on the connections tab, see the manual here: https://dev.mysql.com/doc/workbench/en/wb-manage-server-connections.html