Hi all...long time no post.
Here's a mysql issue my site is experiencing. Mind you, my site was recently upgraded to a new VDECK and new PHP Admin. Hmm...
I have a bi-weekly script I run which points to my supplier's database, opens 2 tables, and extracts inventory information. I have a standard script to set up the server, user, pw, etc.:
$server = 'xxx'; // server location
$user = 'xxxxxxxxxx'; // db username
$password = 'xxxxxx'; // db password
$db = 'xxxxxxxxx'; // db name
$link = mysql_connect("$server", "$user", "$password") or die(mysql_error());
$db_selected = mysql_select_db($db,$link);
But the last time I successfully ran the script was early June. I have been getting the following error for 2 weeks now:
Can't connect to MySQL server on 'mysql-3.db.vi.net' (111).
whenever I run
CHEAP SKATEBOARD SHOP: DECKS, TRUCKS, WHEELS | www.Getmea-Skateboard.com. I've tried writing other scripts, no dice.
I checked with my supplier (and sent them my code) and their dba said he has no problem accessing the db from their end...nothing has changed...etc.
What do you think has happened here? Has PHP or mySQL locked out access to dbs outside of my domain?
Thanks in advance...