Remote access to mySql

[latex88]

Hi,

I have a mySql database residing at a hosting server. I would like to be able to link to the tables to extract data. I understand that I can connect via ODBC method? Can someone help with this connection?

 

[DCrake]

Try this link

 

[Banana]

You'll definitely want to heed DCrake's advice with DNS-less connections. This link is for SQL Server, but you can adapt to MySQL. You'll need to download MySQL ODBC driver.

Here's a step-by-step guide for linking to MySQL in Access. You can then convert to DNS-less connection for easier distribution. You may also want to read this.

 

[latex88]

I am informed by my hosting server that because it is on a UNIX platform, I cannot connect using MS Access. Is this accurate?

 

[Banana]

Bullsheet.

I've built a UNIX server, run MySQL on it and use Access clients against that MySQL server.

(they may thinking of different protocols but ODBC is fundamentally client-side; as long you have MySQL ODBC driver installed on your users computer, that's all they need)

PS: On second thought, if they meant to say they don't allow remote connections to their MySQL server, that may be why they said that. Not all hosting plans allow you to have remote connection to the resources other than the web. You may need to upgrade your plan or get other hosting provider that allows non-web-connection or maybe just provide a mean of logging in the server using SSH.

 

[latex88]

OK. I called the server company and the other guy says I should be able to tab in. I've downloaded the driver, although I believe it was already installed already. When I tried to connect, I get below error message

Connection Failed: [HY000][MySQL][ODBC 5.1 Driver] Can't connect top MySQL server on '..............com' (10061)

I have had similar error message when I tried to use another 3rd party software before, which is Navicat. It is the reason I am trying to use MS Access instead.

I'm beginning to think I have log-in issue. I used the same credentail when using PHPMyAdmin. Am I supposed to use 'root' as user name?

 

[Banana]

Because it's hosted, I'm not sure if you even have root privileges so logging in root wouldn't help. Besides you really, really don't want to do that.

Two things to try.

1) When configuring ODBC Driver, did you use Test?

2) Use telnet to verify you can reach the server.

telnet your.server.address.com 3306

If you get something like this:

Trying xxx.xxx.xxx.xxx...
Connected to localhost.
Escape character is '^]'.
4
5.1.30V4rd!q:lOz8E5vtdySrc
Connection closed by foreign host.

(the penultimate line refers to version so may differ)

then you know you can in fact reach the MySQL.

 

[latex88]

I just received confirmation that becuase it is a shared hosting platform, it does not allow remote database access. That really sucks. Now I have to use phpMyAdmin, which is not user-friendly at all.

Does anyone know a good hosting company that does allow remote access to MySQL database?

 

[Banana]

Just google for any provider that allows remote access. Some can be shared, other may insist that you buy a higher tier (e.g. a dedicated server instead of shared hosting).

Rackspace, maybe?