|
|
||||||
|
||||||
| Index Link To US Private Messages Archive FAQ RSS | ||||||
| Database Discussion Forum This is the place to find help resolving those nagging questions you have about implementing and using all kinds of databases. Need help writing a query? Need an opinion on Oracle? Post here! |
Share Thread: & Tags
|
||||
|
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|||
|
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... |
|
|||
|
Hi, Wige...thanks for the reply...
Unfortunately, my webhost is tighter than a...well, it's tight. I am unable to perform command-line activities. Still trying to get an answer from my webhost... |
|
|||
|
I spoke too soon...I did not want to mention the web host's name, but here is iPower.com's response:
We apologize for any inconvenience this may have caused you. We have checked the issue and noticed that you are using database which is not present on our server. Unfortunately, this is not possible to use a database present in external server. You have to create that database on our server in order to resolve the issue. If you have any further questions, please update the Support Console I've been running this externally-pointed db script for 8 months! This is the last straw. First, they blocked data file imports into mySQL (.xls); this made data updating extremely time consuming on my own db...next they blocked PHP scripts pointing to an external domain...now this! I am so frustrated over these guys... |
|
|||
|
It could be privileges issue where your new host is not allowed to access db.
If you didn't do it already try issuing command from mysql client, logged as admin: GRANT SELECT ON mydb.* TO 'someuser'@'%' IDENTIFIED BY 'some_pass'; If you don't use linux, there are windows mysql clients too. If they really don't allow access to external database, you can move the db files to your server or change the host. |
|
|||
|
had connection problems with mysql, solved them with this
MySQL can't connect Error - FixYa Hope it will help you, Yuri. |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| mySQL Too Many Connections Open error | getmea | Database Discussion Forum | 17 | 12-19-2007 08:56 AM |
| Can't connect to new SQL database | spenland | Database Discussion Forum | 3 | 03-27-2006 06:52 AM |
| Can't connect to new SQL database | cyanide | Database Discussion Forum | 0 | 03-06-2006 11:09 PM |
| Server Error 500 on PHP/MySQL site | MarcieZoob | Web Programming Discussion Forum | 6 | 07-17-2005 07:02 AM |
| Script Time Out Error with MySql Database | printas | Database Discussion Forum | 1 | 05-04-2004 01:31 AM |
|
WebProWorld |
Advertise |
Contact Us |
About |
Forum Rules |
MVP's |
Archive |
Newsletter Archive |
Top |
WebProNews
WebProWorld is an iEntry, Inc. ® site - © 2009 All Rights Reserved Privacy Policy and Legal iEntry, Inc. 2549 Richmond Rd. Lexington KY, 40509 |