Tried everything and I can't connect to MySQL

[cka2007]

All,
I am trying to connect to a MySQL Database from my local computer and I can't do it to save my life.

The MySQL database is on the GoDaddy server. I am using MyODBC version 5.1 on my local computer and I input the Data Source Network, Server, the port is 3306, username, password, and database name. I have entered this several times just to make sure everything is correct. The host or server name is: kycoaches1.db.2105404.hostedresource.com / the dsn is: mysql_kycoaches1.dsn / the database name is: kycoaches1

I have also disabled my firewall and antivirus. I went into my Linksys Wireless-G broadband router (model WRT54G) and changed certain things in there to allow access, BUT if there is something specific I need to change, I hope someone can tell me. With the changes I made I still can't access the database.

Here is the error I am getting when I try to connect:

Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'kycoaches1.db.2105404.hostedresource.com' (10060)

I really think it is some network issue, but I don't know what to change to allow me access to the MySQL Database.

Can someone PLEASE help me?????

 

[ingresman]

The 10060 is a winsock error and seesm to be a timeout (why it times out is the real error). Have a look at

http://support.ipswitch.com/kb/WSK-19980714-EM32.htm

Have you asked godaddy what values you should be providing. Some hosts don't allow remote connections into db's.
I was thinking of trying godaddy, so I'd be interested in your findings.

 

[DonQuichote]

On the command line (DOS box or unix terminal window), try:

ping kycoaches1.db.2105404.hostedresource.com

For me, this does nothing: I don't get an answer. This suggest that there is a network issue. Further test:

telnet kycoaches1.db.2105404.hostedresource.com 3306

Also yields no response. This suggests that port 3306 on that address cannot be reached. It may be possible that this is accessible for your IP adress if GoDaddy configured it that way. So if this is reachable for you, you can try looking at the MySQL server. If not, it is a network issue.


+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[cka2007]

You know what I will call GoDaddy and see if they can provide some insight based on your pings.

Thanks for that information.

They don't really have technical customer help people at this level, so I might have to ask for someone more advanced if they can find that person

Whatever the case, I will reply back if I ever get a solution.

Someone here at my job also told me to try pinging, but I am not home to try it, but you have already done that and no response.

Someone also told me to try plugging my computer directly into the Qwest Modem vs. my Linksys modem to see if that worked, BUT if you did a ping and no response to that server, then that will not work either.

Stay tuned...

 

[cka2007]

All,
I have the solution for the problem.

It was a problem on GoDaddy's side.

Once I told them that someone had pinged the server, and there was no response, they knew it was a problem on their end.

They had to move me over to a server that had "Remote Access" for databases.

I think the hosting package that my client purchases was a Basic package that didn't include that as standard.

I hope this helps someone else out, because it caused me a lot of heartache and pain

I REALLY appreciate you alls' help in troublshooting to let me realize that it wasn't a problem on my end.

Everyone Please have a great day!!!

 

[smays]

cka2007,

What did you end up *doing* to remotely connect to your MySQL server? You mentioned disabling your firewall and your antivirus stuff: ultimately was that necessary?

I find the notion of a database server residing on a hosting service (GoDaddy, for example) interesting. I have no need at the moment, but I often wonder what I could do with such a thing. That said, now I am being nosy: (in general, you don't have to be specific) on the client side what are you using to connect to the MySQL server? GUI tools? A compiled language? A scripted language? In your original post you mentioned the error was reported from the ODBC drivers, so I am assuming some kind of programming language.

Thanks,
Steve.

 

[cka2007]

Yes GoDaddy had to move my database over to a server that allowed for "Remote Access"

Also, they had to move me from a Windows Operating System to Linux, because I required PHP 4 or above.

I am using a tool called PHPRunner to connect to the database remotely, which allows you to create forms, reports, queries, etc. and display in anyway you want. I also had to install myODBC 5.1.

That's it.

 

[DonQuichote]

, because I required PHP 4 or above.

Say what? PHP4 is quite some time end-of-life now. Do you really mean they run something even older?


+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[cka2007]

yes on the Windows Operating System

 

[ingresman]

Thier web site says php4 or 5 on windows. They also offer .net 3.5 which is the latest on GA.
I'd get back to them about your options, as Don says 4 is quite old now.