Connecting from one server to mysql on another server
StuntasticAudi
10:45 pm on Feb 28, 2007 (gmt 0)
I need to connect to a database that is on a different server. What do i put for the hostname and how do i connect to it.
Step by step would help..thanks
phranque
11:49 pm on Feb 28, 2007 (gmt 0)
in general, you have to: - grant access to the user on the remote host in the mysql database on the db server - make sure the mysql ip port is open (3306) - turn on networking in the configuration file (my.cnf) - specify the remote host when connecting to mysql, either by providing the argument in the access library method or using the -h option in the command line.
