A scholarship-winning UCC student from Waterford, who was struggling while studying away from home, was found dead in his bedroom after taking a lethal cocktail of prescription drugs mixed with heroin.