SET GLOBAL local_infile=1;

START TRANSACTION;
LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE dbname.tabname
FIELDS TERMINATED BY ':'
LINES TERMINATED BY '\n'
(pwhash, count);
COMMIT;