I think the best thing is to get over the feeling that you have to please other people. There will always be people in your life--maybe family, or partners, or close friends--whose opinions will matter more to you than others, but in the end, it is yourself whose happiness you are responsible for, and if you can let go of that need to please others all the time--because you can't, it's simply impossible--you will be happier, I think. I'm not saying it's easy to do this--some of us were taught from our earliest days to feel responsible for the happiness of others, or to need the approval of others, and it's a hard thing to let go of. But I find that the more I can do it, the happier and more at peace with myself I am.
Good luck in finding a job that suits you.