if there is no leak when you tighten the faucet handle,

then there is nothing wrong with the faucet. 

It is the connection of the hose to the faucet that leaks. This happens all the time and I hate that. These days you simply can't find a good product.