I have a windows Vista box that i can RDP into. It's running as a MySQL server. I have a webserver too with PHP installed and the dlls for PHP. So i put a script on the PHP server to input a file into the MySQL server. The file is this.
$mysql_host = "10.1.8.182"; //MySQL host
$mysql_user = "as400"; //MySQL Username
$mysql_pass = "inventory"; //MySQL Password
$mysql_login_db = "patients";
$conn = mysql_connect ("$mysql_host","$mysql_use
r","$mysql
_pass");
mysql_select_db ("$mysql_login_db") or die(mysql_error());
//$result2=MYSQL_QUERY("TR
UNCATE patientinfo");
$result=MYSQL_QUERY("LOAD DATA INFILE 'C:/AS400/MR3L09F.CSV' INTO TABLE patientinfo FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';");
but that won't run i get the following MySQL error.
Can't connect to MySQL server on 'localhost' (10061)
as you can see im not connecting to localhost but it thinks i am. And i tried making sure that MySQL was setup for remote connections but the only tutorials i found were for SSH and linux. Is there any simple way to setup remote connections and is there something else i may be doing wrong?
Start Free Trial
