Quickheat wrote:
With the A record yes - although I am unsure how to specify a specific VDS directory to use a subdomain, since the target can only be the VDS IP and not a directory on the VDS. I.e. if my main page hosted on the VDS was forums at forums.example.com, I cannot then specify 0.0.0.0/phpmyadmin to use phpmyadmin.example.com, instead it would use forums.example.com/phpmyadmin, correct?
Yes, this is correct.
If you are using apache, you can set up "vhosts" which will allow you to assign an IP address per directory. So for example, if you have 192.168.1.1, and it has a record of phpmya.site.com with a directory of public_html/phpmyadmin, you can set this, and it will be solely phpmya.site.com with no folder trail.
Quickheat wrote:I have not tried FTP yet. Right now I am trying to configure MySQL to work on the VDS. It is installed fully, I have PHPMyAdmin, have setup my databases etc. except nothing can connect to the databases (Lost connection to MySQL server at 'reading initial communication packet'). According to online port checkers, 3306 (the MySQL port) is closed on my VDSes IP address as well
I don't think I have ever gotten an online port checker to work on NFO, but regardless -- all ports are open. Windows Firewall is also automatically disabled as NFO has their own firewall settings in your control panel ("firewall - beta" tab).
Are you trying to cross connect the database to a different web server and/or game server; vice versa? If so, you will need to enable external connections.
Go to:
/etc/mysql/my.cnf
Change:
bind-address = 127.0.0.1
To:
#bind-address = 127.0.0.1
This will allow any IP address to connect to the database, given it provided the correct login information.
In addition, if you are utilizing the login details on the VDS in a web application, do not use "127.0.0.1" as the DB Host, use "localhost".