|
| |
|
|
carrie
Posts: 251
From: Port Orange, FL Volusia
Status: offline
 |
remote access to mysql db - 6/28/2006 11:51:16
Hi all,
I've just setup a VPS linux account at godaddy.com. It comes with a default mySQL database that they say I can connect to remotely, by using the IP address, but they offer little support.
Is there some initial setup that needs to be done on the server to allow remote access to the mySQL db? I can't seem to connect with the connection string - I get a 10060 error.
Using Plesk control panel & SSH to connect. Any help would be appreciated.
Carrie
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: remote access to mysql db - 6/28/2006 11:58:31
I believe you can use the mySQL Administrator to connect to a remote using an IP adress and the proper credentials (username/password etc.).
That is downloadable from the mYSQL web site if you don't have it already.
That help any?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
carrie
Posts: 251
From: Port Orange, FL Volusia
Status: offline
|
RE: remote access to mysql db - 6/28/2006 13:37:14
Oh yeah,
I've already done that:
Dim oConn, oRs
Dim qry, connectstr
Dim db_name, db_username, db_userpassword
Dim db_server
db_server = "IPaddress"
db_name = "dbname"
db_username = "username"
db_userpassword = "pwd"
'fieldname = "your_field"
'tablename = "your_table"
connectstr = "Driver={MySQL ODBC 3.51 Driver};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open connectstr
When I try to run the code, I get a 10060 error ([MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IPaddress' (10060)) I am able to use the above when connecting to other mySQL db's - but this db happens to be the default db on the VPS at localhost. I'm pretty new to VPS's and I've been finding my way around, but I wasn't sure if something had to be setup on the VPS to allow remote access. If anyone knows setup for VPS on linux, please let me know.
| |
|
|
|
carrie
Posts: 251
From: Port Orange, FL Volusia
Status: offline
|
RE: remote access to mysql db - 7/3/2006 17:03:36
Thanks Spooky,
Since I posted here, I contacted Tech support and they said they do not support remote connections from their own servers. In other words, I was trying to connect from a shared hosting account to the VPS account local db - but they won't allow it.
I found hosting at another provider that confirmed a remote connection would be possible, but it appears they don't have mySQL drivers installed on their servers. Waiting to hear back.
Carrie
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
