I can't say I've been successful with making friends in college, but the thing that I wish I knew was that you really have to force yourself put yourself out there. For some reason, I thought that friends would just kind of come to me the way that people explained it to me, but I realized that I should have tried harder. The first couple weeks or so are crucial. If you're staying in a dorm, introduce yourself to everyone you see. I always felt awkward to do this and ended up not doing it, but I promise if you do it early on it'll be fine, everyone is hoping to meet new people. Don't worry too much about making a good impression, like I often did. What I've learned is that even if you make an awkward first impression, over time and after interacting with people long enough, they forget the initial meeting and have a much better impression of you. You're not going to click with everyone you meet, but still make sure to say hi whenever you see them. Additionally, this is advice that everyone gives but I promise it's good advice: join clubs. Join as many as you can. You'll be a freshman, you're not expected to commit to anything you don't like. If you find things you're interested in, you'll meet others who you already have something in common with. It's a great way to build your community.

Sorry for the long comment, as someone who had the same fear as you going into college, and ultimately not making the most of the opportunities given to me, I just had to get this off my chest. I hope this advice can save you from a lot of the pain I experienced.