Locked out of my local site after transfer
well you can first 

drush upwd --password="yourNewPassword" UserName


to reset your password.

then you would need to remove the attempts so you can try to login again, you need to truncate the table flood.

TRUNCATE TABLE flood