After wasting time and money trying to get my server hosted on DreamHost (I mean, why the fuck would you sell me VPS space and then NOT give me root/sudo access to it) I decided to go through the tutorial posted here in MPGH.
(Huge shout out to CSEngineer13 for the guide - it's literally just called Hosting Fabiano on a Linux VPS if anyone cares to reference -I'm not allowed to post links yet)
I'm actually a good way through the tutorial actually.
I have MySQL and phpmyadmin installed and apparently working in that I can enable and disable them as services through putty.
Unfortunately the tutorial seems a little dated now. We're up to mysql 7+ for example, so a few things didn't apply here.
On to my issue, I am at #7 in the "Preparing the VPS" section. The part where I'm supposed to add the game's database to my SQL instance.
But when I try to access phpMyAdmin I get the following error:
#2002 - Connection refused -The server is not responding (or the local server's socket is not correctly configured).
I've scoured stack overflow forums for answers but everyone's solutions appear to be different and I really don't have the experience to just mess around with components I don't fully understand. I don't want to wreck the work I've done thus far.
I'm kind of learning all of this as I go along and I'd like to think I've come pretty far. And it looks like I'm sooooooo close to getting my game up. But this here stumps me.