Although not strictly MYSQL, can you please help me understand connecting to one. The difficulty is that I cant connect but there are many reasons for that and each one is a whole subject on its own.
I did have this running a few years back, but the install program back then must have set up everything automatically as it worked out the box.
Here are my thoughts.
127.0.0.1 is the local host address.
1: Is the 3306 a port that connects the DB to 127.0.0.1 (Settings in mysql.cnf or similar)
2: I presume that the server needs to open this address to be accessed externally. (Settings in mysql.cnf or similar)
3: Is remote access to DBs on the server related to each DBs or the complete MYSQL system. If each db then sql commands to set it, if not in mysql.cnf.
4: Do I need to allow remotes IP address to be known to the server. Something like 0.0.0.0:*
Judging by the number of hits you get googling Connect to MYSQL, this is real issues with "many" solutions but each only seems to address on aspect of the whole process.