I Cannot Connect Either

[BGG16]

I just downloaded SQLyog, with the understanding that it was a program similar to MS Access in that it would allow me to create a database visually like Access does (all I have previously used is Access, and I have never tried to use it to create a dynamic site). I have remote hosting for MySQL on a godaddy server, but when I try to connect, it says: Error No. 2003 Can't Connect to MySQL server on 'mysql57.secureserver.net' (10060).

Two questions:

1) Any idea what I am doing wrong in trying to connect to the MySQL server?

2) Am I correct in believing that SQLyog will allow me to create a MySQL database visually, similar to Access or Excel in visual layout?

Thanks!

[peterlaursen]

Quote:

Any idea what I am doing wrong in trying to connect to the MySQL server?

Most likely you will have to use some sort of tunnelling to connect. Refer to the SQLyog helpfile on that. Is says to be a “secure” server. What protocol does it allow for: HHTPS, SSH ???

Quote:

Am I correct in believing that SQLyog will allow me to create a MySQL database visually, similar to Access or Excel in visual layout?

Acces and MySQL are not comparable – they are two very diffent things. You should not expect SQLyog to present a MySQL database as Access presents its databases. But it is a GUI (=visual) tool.

[NlGhT]

I had the same problem, Actually that's the reason I entered this forum.

I am using MySQL version 4.1 with SQLyog.

When I installed these programs I noticed that some folders were placed at the start button.

What I did was:

1.-Go to start button

2.-Go to Programs

3.-Go to MySQL

4.-MySQL Server Instance Config Wizard

5.-Keep on pressing next until an execute button apears

6.-Press the execute button

7.-Try to connect again

–I read that if you have a firewall protection or a Zone-Alarm program or Norton Antivirus you will not be able to connect (that was not my case).

–I also read that if you are connecting to your localhost you must use “root” as your username.

–The port you need to put in order to connect is: 3306.

–If you are trying to connect using a different address (not localhost, as is the case of the poster of this topic), then you have to configure a tunnel using SQLyog.

To configure it just open SQLyog:

1.-go to file

2.-go to connect

3.-go to tunnel

4.-Check the box: “USE HTTP tunneling”

5.-put the URL of your site.

If you encounter with problems click on the question mark to get some help about configuring a HTTP tunnel(or the other type of tunnel aswell).

(NOTE: If you are not using the Enterprise edition you will not be able to configure this tunnel.)

I'm sorry if this post didn't help you. I just tried that and it worked for me.

Regars

NlGhT

[Gorka Llona]

Hi,

I'm trying to connect to a MySQL 5.0 DB on Ubuntu 6.10, from a Windows machine. When I try, I get the same error:

Error 2003: Can´t connect to MySQL Server on '192.168.0.10' (10061)

I think everything is configured ok at the server:

– I granted access to user 'root' from server '%'

– I restarted the service

I can not use http tunneling because I don't hace the enterprise version of SQLyog.

Can you help me?

Thanks in advance,

-GG

(just added this comment in order to being email-notified – please ignore)

[MatthewRa]

This still happens – then at some points a week or so later – it goes away …

no action to start or stop the issue – does anyone know the solution/fix when t happens?

[Author]

Posts