Connection Error

[cyanide]

OKay, before anyone freaks 🙄

I have searched the board here. Im getting the Same Error 2003. I think I've tried just about every possible combination of settings. Would be nice if there was some docs around too.

I've alway used phpMyAdmin with no problems. I have root access to the server, although, I'm trying to connect to a database on a website that has a dedicated Ip address. I'm not using SSL encryption feature

What exactly am I supposed to put at the following entires:

MySQL Host Address : I've tried domain.com, http://domain.com, http://www.domain.com, domain IP address, machine main Ip address

Username : I've tried domain username, root, mysql username(domain@localhost & domain_user)

Password : I've tried root password, domain password, mysql password

Database : domain_database

I don't even know what to enter now 😮

Responses and some assistance is highly appreciated

I forgot to mention, I have a firewall on my desktop. I have tried disabling it and it does have sqlyog in its permissions, but to no avail

[Ritesh]

Fill in the following details:

MySQL Host Address: IP address of the machine on which MySQL server is running.

Username: Your MySQL username. Its the same as in phpMyAdmin.

Password: Your MySQL password. Its the same as in phpMyAdmin.

Database: The database you are going to work on. You can leave this field blank if you want to work with all the databases in the MySQL server.

Note: Make sure that the server is up and running and you have correct privileges to connect from a remote host.

[Shadow]

At first, make sure that you are allowed to connect from a remote host, at all! PHPMyAdmin runs locally that's why it connects without any problem. Most ISPs do not like granting direct remote access for security reasons.

[cyanide]

Thanks very much for the replies!

Shadow wrote on Aug 23 2004, 04:51 PM:

At first, make sure that you are allowed to connect from a remote host, at all! PHPMyAdmin runs locally that's why it connects without any problem. Most ISPs do not like granting direct remote access for security reasons.

hmmm… I was actually wondering the same thing. I have a feeling that's probably it.

I'm going to look into it now

Thank you

[grendel]

Hi, I have the same problem, same error message, but I only just tried to open SQLyog locally. I checked my firewall, just in case, that was not it.

So I can't even get started, any idea anyone?

[Shadow]

Grendel: Do a little search next time before asking, please! You get this message if no MySql server is running on the specified host listening to the given port.

[summertime]

@grendel

One aka *the* problem ist, that You cannot putin e.g. username:[email protected] or username:[email protected] — so the login with SQLyog fails. Possibly a feature that yog should have in future — like competive products.

regard summertime

[summertime]

@shadow

what kind of “security reasons”? (its often a fairy tale)

Most of the connetion problems are on the Yog-side (not on the remote server-side). proxy-connections including socks4/5 or tunneling is not a Yog-feature (yet).

[Shadow]

Quote:

username:[email protected] or username:[email protected]

Why do you want to enter such data to the connection window?

No database (not just MySql) is ever exposed directly to the whole internet because some “good-willed' people could take the db server down in minutes. It's a fact, not a fairy tale. They might grant you direct access based on IP or host name but even this is not common. This is exactly why SQLyog's team is working on a PHP-tunnel. Besides tunneling can be done easily with separate programs, this issue has already been extensively discussed in this forum.

[summertime]

we are testing a new hoster – crediblehost.com. With yog You cannot connect; with mySQLfront You cannot connect – even using php-Tunnel. But if You login – like described here – with user:password@…. then You can connect by php-Tunnel.

When I think about 50-60 very good programs on the market which connect to remote mySQL-database (otherwise they would be useless), than I suppose that there are 10.000 or 20.000 users who connect to mySQL from remote. Lets think only to the user of ODBC and we can say there are 100.000 users who connect by ODBC (or ADO ….) to remote mySQL-servers.

In many companies I know there is MS-Access as front-end and mySQL on a remote hoster; all connecting. So the security-argument (which is very often in political context too) is a fairy tale. As You point out, its very easy (but sometimes complicated for semi-skilled people) to reduce connection-rights to the individual customer.

The “localhost” is much more easier that listing ip-addresses, which are useless at dynamic IP's. For me it's not a security problem, it's a problem of willing to do a good work.

Even when You allow “%” in host, there are dozend of other restrictments to fulfill for “abusing” a system. And as the ODBC-commutity shows since more than 10 years – there are no security probs — if You have skilled people.

Regards summertime

[Ritesh]

cyanide wrote on Aug 23 2004, 09:02 PM:

Thanks very much for the replies!

Shadow wrote on Aug 23 2004, 04:51 PM:

At first, make sure that you are allowed to connect from a remote host, at all! PHPMyAdmin runs locally that's why it connects without any problem. Most ISPs do not like granting direct remote access for security reasons.

hmmm… I was actually wondering the same thing. I have a feeling that's probably it.

I'm going to look into it now

Thank you

Check out http://www.webyog.com/forums/index.php?act…st=0&#entry3610

[Author]

Posts