Forums » General Discussion

Thread: NEW CONNECTION FAILURE WHEN I CHOOSE CONNECT TYPE IS TCP!

This question is answered. Helpful answers available: 1. Answered answers available: 1.


Permlink Replies: 6 - Pages: 1 - Last Post: Jan 26, 2011 10:59 AM by: Mauritz
leeyeonho

Posts: 5
Registered: 1/20/11
NEW CONNECTION FAILURE WHEN I CHOOSE CONNECT TYPE IS TCP!
Posted: Jan 20, 2011 4:56 PM
 
  Click to reply to this thread Reply

HI THERE.

I'M USING TOAD FOR MYSQL NEWEST VERSION.
BUT, I CAN'T CONNECT TO TARGET SERVER.


HERE IS,

CONNECTION MANAGER INFORMATION.

- CONECTION TYPE : TCP
- HOST:XXX.XX.XXX.5 <-- TARGET SERVER.
- USER:XXX
- PASSWORD:XXX
- DATABASE:XXX
- PORT:3306
- COMPRESS:NO CHECK

I WAS INPUT ABOVE SERVER VALUES. THEN, I CLICKED CONNECT.

AND BRING UP TO ME. HERE IS ERROR MESSAGE.
Access denied for user 'XXX'@'XXX.XX.XXX.156' (using password: YES)

IT IS TOO CRITICAL ERROR. RIGHT?

I'D INPUT IP ADDRESS XXX.XX.XXX.5 LAST PREFIX! BUT, THIS MESSAGE ARE XXX.XX.XXX.156
SOMETHING WRONG?


AND, THIS ERROR IS OCCURED BETA VERSION. ALSO. Message was edited by: leeyeonho


Mauritz

Posts: 313
Registered: 8/23/07
Re: NEW CONNECTION FAILURE WHEN I CHOOSE CONNECT TYPE IS TCP!
Posted: Jan 21, 2011 10:37 AM   in response to: leeyeonho
 
  Click to reply to this thread Reply

Could you please check if you also get this error in the just release beta for version 6.0?


leeyeonho

Posts: 5
Registered: 1/20/11
Re: NEW CONNECTION FAILURE WHEN I CHOOSE CONNECT TYPE IS TCP!
Posted: Jan 21, 2011 5:00 PM   in response to: Mauritz
 
  Click to reply to this thread Reply

HI.Mauritz


I'm checked freeware v5.0 and beta 6.0. all of them are occured same error. Message was edited by: leeyeonho Message was edited by: leeyeonho


Mauritz

Posts: 313
Registered: 8/23/07
Re: NEW CONNECTION FAILURE WHEN I CHOOSE CONNECT TYPE IS TCP!
Posted: Jan 23, 2011 11:17 AM   in response to: leeyeonho
 
  Click to reply to this thread Reply

This is very strange.

Does the computer with the XXX.XX.XXX.5 IP also have another interface on XXX.XX.XXX.156?

Can you connect to your server using any other tool except for Toad (For instance the mysql command line)?

/Henrik


leeyeonho

Posts: 5
Registered: 1/20/11
Re: NEW CONNECTION FAILURE WHEN I CHOOSE CONNECT TYPE IS TCP!
Posted: Jan 23, 2011 4:33 PM   in response to: Mauritz
 
  Click to reply to this thread Reply

Hi. Mauritz.!


Does the computer with the XXX.XX.XXX.5 IP also have another interface on XXX.XX.XXX.156?
--> no, there is only have xxx.xxx.xxx.5

I'm using mysql workbench, and Tera-term(command line).
but, I was OK.


It' error was only occured toad.

I thinks it so very strange.

Message was edited by: leeyeonho


Andrew B

Posts: 1
Registered: 1/26/11
Re: NEW CONNECTION FAILURE WHEN I CHOOSE CONNECT TYPE IS TCP!
Posted: Jan 26, 2011 10:54 AM   in response to: leeyeonho
Helpful
  Click to reply to this thread Reply

I ran into the same problem today. I think the issue is in the fact that, right now, Toad doesn't support MySQL Server 5.5, it only supports up to 5.1. Honestly, if that's the issue then the error should be better worded...



Mauritz

Posts: 313
Registered: 8/23/07
Re: NEW CONNECTION FAILURE WHEN I CHOOSE CONNECT TYPE IS TCP!
Posted: Jan 26, 2011 10:59 AM   in response to: Andrew B
 
  Click to reply to this thread Reply

The error message comes from the MySQL connector, it is not generated by Toad. I will investigate if this is related to MySQL 5.5.


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums