servers and mysql database question - GoFuckYourself.com

aaajjj · 09-23-2003, 03:13 PM

it is possible to access a database from a server without accessing any page on that server?

for example let's say that i have 2 dedicated servers; on server1 i have database1; if i know the users and passswords for databasename1 it is posible make that: when a visitor visit the page site2.com hosted on server2 to introduce some info (for example the ip of the visitor) in the database1 from server1?

hope i make me understand

NetRodent · 09-23-2003, 03:17 PM

liquidmoe · 09-23-2003, 03:17 PM

Yes. Whenever you add a new user to mysql to access some database you can explicitly say user@ip address, usually you add the username as user@localhost, or it defaults to localhost if you dont include anything. Just add a user@server1_ip on server2 where you run mysql. Then server1 will be able to connect to the mysql database on server2 by specifying the ip address instead of localhost when establishing the connection in your CGI script and you can have full access to that database.

If you need any help or have any questions hit me up on icq at 36837470.

Take care

aaajjj · 09-23-2003, 03:24 PM

Quote:

Originally posted by liquidmoe
Yes. Whenever you add a new user to mysql to access some database you can explicitly say user@ip address, usually you add the username as user@localhost, or it defaults to localhost if you dont include anything. Just add a user@server1_ip on server2 where you run mysql. Then server1 will be able to connect to the mysql database on server2 by specifying the ip address instead of localhost when establishing the connection in your CGI script and you can have full access to that database.

If you need any help or have any questions hit me up on icq at 36837470.

Take care

thank u very much.. if i will need help i will hit u up.. thanks again

09-23-2003, 03:13 PM	#1
aaajjj Registered User Join Date: Sep 2003 Posts: 13	servers and mysql database question it is possible to access a database from a server without accessing any page on that server? for example let's say that i have 2 dedicated servers; on server1 i have database1; if i know the users and passswords for databasename1 it is posible make that: when a visitor visit the page site2.com hosted on server2 to introduce some info (for example the ip of the visitor) in the database1 from server1? hope i make me understand

09-23-2003, 03:17 PM	#2
NetRodent Confirmed User Join Date: Jan 2002 Location: In the walls of your house. Posts: 3,985	Yes __________________ "Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats." --H.L. Mencken

09-23-2003, 03:17 PM	#3
liquidmoe Confirmed User Join Date: Mar 2002 Location: NY Posts: 4,994	Yes. Whenever you add a new user to mysql to access some database you can explicitly say user@ip address, usually you add the username as user@localhost, or it defaults to localhost if you dont include anything. Just add a user@server1_ip on server2 where you run mysql. Then server1 will be able to connect to the mysql database on server2 by specifying the ip address instead of localhost when establishing the connection in your CGI script and you can have full access to that database. If you need any help or have any questions hit me up on icq at 36837470. Take care