99% of people really enjoy uni in the end, I think. Student room isn't exactly representative.
Loads of people get on with their flatmates really well at first then fall out later when they find other people they like more than the first half dozen they happened to meet at uni- but this isn't a big deal it just happens and it's not worth stressing about.
I personally discovered that I loved clubbing having never been before and barely having touched alcohol in my life before I came to uni.
It's not hard to get to know people in the first few weeks- everyone is really really sociable because they're all in the same situation...
You say hi, ask people their name, their course and which part of the country they're from. Then when you see them again you both awkwardly try and remember the answers from last time and fail but it doesn't matter because you've both made the same mistake. Repeat x1000 for three weeks until you actually know loads of people. Piece of cake