trying to make a 1and1 root server a DB server....
Linux - NetworkingThis forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
trying to make a 1and1 root server a DB server....
Is this even possible to use the server as a DB only server and use my windows dedicated server through 1and1 as an appllication / webserver running php / IIS, I've been searching online and enabled port 3306 in the firewall, commented out the skip-networking in my.cnf and restarted but I still can't seem to connect remotely,
Is this something that should be done? can it be done?
is there a walkthrough somewhere online , I found a thread on this site but after following the steps I still can't connect, can someone point me in the right direction
Are you able to connect to the machine remotely. FOr example ssh to your user-account? Remember to disable root login, before you permit ssh to listen on external ip.
The 1and1 machine you have set up as a mySQL server needs to have the correct info in the mysql database. ie: grant access to ip.ad.dr.ess using userid identified by password ... to add an entry to the correct table. Sorry I don't remember if this is the exact syntax. Look up the proper way to use the grant access command in the mySQL docs.
Then from your windows machine, in php you can connect using the ip address of the mySQL server as the host(http:_slash_slash_ip.ad.dr.ess), specify the database name, the userid and password.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.