error no 2003

[piotrv]

I get error no. 2003 (????) when trying to creating a connection to mySQL from SQLyog.

mySQL host: linux box in LAN, server listening on port 3306

I have setup a testuser for a dabase with host permissions set for my windows machine running SQLyog, but whatever I try i cannot create a connection.

Should I have to do port forwarding thru SSH?

my linux box is running SSH2.

Please help!

Piotr

[CalEvans]

From:

http://dev.mysql.com/doc/mysql/en/Error-returns.html

Quote:

ERROR code 2000 to 2999 can be found in the MySQL source code file: `include/errmsg.h'

Example: 2003 – Can't connect to MySQL server on 'xxx.example.com' (10060)

#define CR_CONN_HOST_ERROR 2003

( “include/mysqld_error.h” contains ERROR code 1000 – 1??? )

Is your server listening on ip addresses other than localhost? (127.0.0.1)

You shouldn't have to do port forwarding, however, if the server is on the Internet then I recommend limiting mysql to localhost and use an ssh tunnel to get to it. It's a little more secure.

HTH,

=C=

[piotrv]

CalEvans wrote on Apr 19 2004, 02:01 AM:

Is your server listening on ip addresses other than localhost? (127.0.0.1)

You shouldn't have to do port forwarding, however, if the server is on the Internet then I recommend limiting mysql to localhost and use an ssh tunnel to get to it.  It's a little more secure.

HTH,

=C=

Cal,

my.cnf is empty, so I presume mySQLis not just listening on the localhost (???)

Should I add this?

bind-address=127.0.0.1, 10.0.0.%

My LAN is subnet 10.0.0.x (i am not sure if I have to use comma-seperation in my.cnf)

The server will be on the internet, so I should set it to localhost only.

But for now I wish I could get SQLyog working whatsoever!!

http://dev.mysql.com/doc/mysql/en/Error-returns.html.

Thanks for that! I dind't know where to look for the return codes, It may help demystifying the problem.

On that page I also found something about Debian specific problems in regards to connecting to mySQL over tcp/3306. It might have to do with this problem as I also got error 2013.

I have to sort this out and do some testing (next week) before blaming SQLyog, hahaha!

I am not a mySQL expert (that is a trivial statement , hihihi)

Piotr

[CalEvans]

Can you log on to your server from the server itself using the mysql command?

An empty my.cnf could be a serious problem. I'm not familiar with how debian organizes it's conf files. MySQL needs something to tell it how to work.

Quote:

bind-address=127.0.0.1, 10.0.0.%

no, try

Code:

bind-address=127.0.0.1, 10.0.0.*

or

Code:

bind-address=127.0.0.1, 10.0.0.0

not sure which one is right. I don't use it in this matter.. Might want to scan the docs. There is a section on the config file that will explain all.

HTH,

=C=

[Ritesh]

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

[codereflex]

'piotrv' wrote:

I get error no. 2003 (????) when trying to creating a connection to mySQL from SQLyog.

mySQL host: linux box in LAN, server listening on port 3306

I have setup a testuser for a dabase with host permissions set for my windows machine running SQLyog, but whatever I try i cannot create a connection.

Should I have to do port forwarding thru SSH?

my linux box is running SSH2.

Please help!

Piotr

[Solved] this url will definitely help you http://bit.ly/etmj1H

[shamimi]

'codereflex' wrote:

[Solved] this url will definitely help you http://bit.ly/etmj1H

i have this problem but my server did have cpanel control 😕 and now how can solve this problem ?

[Author]

Posts