I find the moralising in this thread from people who think they're somehow superior for never having so much as inhaled second hand cigarette smoke so tedious.
People have been taking drugs as far back as you can go - they were tripping off nightshades in 1000BC, the Hindu Veda mentions something widely thought to be magic mushrooms (2000BC) and both Sibera and China have records of their nobility using psychoactive cannabis from 2500BC. Plus alcohol, coca leaves, etc - all been around a long, long time.
The moral panic around drugs is relatively new, in terms of human history.
Obviously, some of it is warranted - supply lines etc.
But the moral judgement of drug use is so pointless - we've been doing drugs for thousands of years and I'd go as far as to argue that seeking ways to make your brain feel different is part of the human experience. Given that we have, decades after the war on drugs swept the globe (cheers Nixon - useless policy with devastating effects), still got millions using drugs worldwide, we'd be far, far better focusing on harm reduction, destigmatising use, and stop pretending we're morally better if we don't use drugs.
Shame, stigma and lack of information are not effective drug treatment programmes or deterrents, trust me.
(To answer your question OP - or kind of - my parents were both honest but not encouraging about drug use. They didn't want me to take drugs but were honest if I had questions, told me about their own experiences with a good balance of 'not denying they can be fun' and 'not ignoring actual dangers'. They told me the advice they wished they'd had - you're often better off not doing them, but if you are, be around people you trust, know where to go if you need help, and know when to stop. And their overriding message in my teens and older was always, if you really need me, I'll be there. So when I had the worst comedown of my life at a weekend event in Birmingham in 2006, my lovely dad heard me sobbing "I just need to be at home, I haven't slept" and drove 3 hours to come and get me and did not even lecture me or ask questions, just occasionally tried to get me to eat something and handed me Lucozade in the car... I've never felt more grateful for anything! As it was I was far less of a wild child than either of them which I think they were hypocritically grateful for...
)