Took medication and gave orders to manager

I'm returning to work soon and just wondering if there's any way to salvage the situation after a month's stress leave. My manager had been pretty supportive until the last day when I took a new anti anxiety medication (looking back, incredibly stupid, but I wasn't sure I'd be able to handle the meetings/lunches etc bring held), had a really bad reaction to it and it was like I was drunk in the office. I acted in a high handed manner with him, which had never happened before and he made it pretty clear he'd prefer if I didn't return. Can't blame him but it really wasn't intentional. I'm looking for other roles but in the meantime, I'm back to work next week and no idea what I'm heading into. Any thoughts/tips/advice - other than I'm lucky to have a job to head back into?