Rob wrote:
Hey there,wondering if some one could point me on the right direction. I have no idea what its actually called but i want to asign my MYSQL to a domain name.So instead of using local host they can use <http://mysql.domainname.com>mysql.domainname.comBasically want this to make my database accessible to our other servers which are hosted at all diffrent places around the world.Could any one give me a brief idea on how this is done ? and the pro's and cons of it.I did trying searching for it but seams i dont actually know whats its properly called i came up with very little. I thinking this is done in apache ? im just guessing herethanks, rob
---------------- End original message. ---------------------What you want to do is partly a DNS configuration issue (setting up an A record with the appropriate host name for the MySQL server machine) and partly a MySQL configuration issue. You need to configure MySQL to respond to TCP/IP on whatever port you choose to run it on (default is something in the range of 3300 or so, I forget the exact default).
Apache has nothing to do with either of those things. Now... pros? You can access the server remotely.Cons? Attackers can access the server remotely. Be sure you know what you are doing and set up the security of the MySQL server correctly. This is not a trivial task and if you get it wrong, somebody may maliciously screw up your database.
Dragon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Venimus, Saltavimus, Bibimus (et naribus canium capti sumus) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --------------------------------------------------------------------- The official User-To-User support forum of the Apache HTTP Server Project. See <URL:http://httpd.apache.org/userslist.html> for more info. To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|