Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Networking
User Name
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.


  Search this Thread
Old 09-14-2008, 06:58 PM   #1
LQ Newbie
Registered: Jul 2008
Posts: 9

Rep: Reputation: 0
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
Old 09-15-2008, 08:34 AM   #2
Registered: Jul 2004
Distribution: arch, rhel
Posts: 134

Rep: Reputation: 22
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.
Old 09-15-2008, 09:25 AM   #3
LQ Newbie
Registered: Jul 2008
Posts: 9

Original Poster
Rep: Reputation: 0
Yes I can login to the machine through ssh, and execute mysql statements from there, Is there a way to use ssh to send the queries in from php?
Old 09-15-2008, 10:08 PM   #4
LQ Newbie
Registered: Aug 2007
Posts: 6

Rep: Reputation: 0
Should be do-able

Hi there,

You should be able to do this.

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 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(, specify the database name, the userid and password.

Hope this helps!



app, db, mysql, network, php, remote, server

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to monitor web server, FTP server, Mail server and database server vodka33us Programming 1 06-16-2008 04:20 AM
How to make DNS Server work with intranet with web site on Unbutu Server? explorer1979 Linux - Server 6 04-04-2007 10:50 AM
is there a way to make a local linux server the time stamp server for win2k? Lleb_KCir Linux - General 2 09-19-2005 07:05 PM
What would I need to make a File Server / Web Server? RHLinuxGUY Linux - General 13 12-19-2004 10:17 PM
How do you make the ip masquerade server/dhcp server broadcast dns to lan cmisip Linux - Networking 6 01-25-2003 10:43 PM > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 11:19 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration