Governor of Yemen's port city of Aden killed in a grenade attack along with five of his bodyguards, news reports say.