A man who once held the record for being the world's heaviest person has died in Mexico at the age of 48.