I HATE college (help?)?

I absolutely hate college, I have been attending a junior college since last September, and I feel like such a dumb ***. I used to be a mostly A with a couple of B's student in high school. I've taken 5 classes in the past two semesters and I've only passed 3 of them (Two classes were 70's the other class was a B) (One class I didn't pass was a 69, the other a 55 and I busted my *** trying to pass those) The only reason I'm even in college was to appease my grandfather, whom passed away in November. Which was absolutely gut-wrenching. What I truly want to do is be a makeup artist. I TRIED to tell my mom this, but she INSISTS because she's paying, and that it was my grandfather's drying wish that I get an Associates Degree at my community college. I am f-ing miserable here, and I feel like I'm so damn stupid that I can't even pass anything. I'm not ready to work full-time at a salon for example as a makeup artist (I've never worked a day in my life, I'm 19) but on the other hand I don't want to continue to waste my parent's money, and continue to be unhappy at college. I haven't even made a single friend, and didn't have any in high school. They all claimed they wanted to be my friend and when summer came around they blew me off. What should I do? Should I continue to stick it out here, and be unhappy? Or try to pursue what I believe I want to have a career in? (Sorry, I didn't know where else to put this.)