Bug #8981 Cannot connect; cannot see error
Submitted: 5 Mar 2005 18:05 Modified: 6 Mar 2005 1:59
Reporter: a.h.s. boy Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.0.6-beta OS:MacOS (OS X (10.3.8))
Assigned to: CPU Architecture:Any

[5 Mar 2005 18:05] a.h.s. boy
Description:
Using a fresh download of MySQL Administrator 1.0.6-beta. When attempting to connect to any of 3 different machines running MySQL, I am unable to establish a connection at all. (Running mysql -h -u -p on the command line from the same machine works fine).

When connecting to 2 remote machines, I get an error:

Could not connect to MySQL instance at
[hostname].[domain].[suffix].
Error: You have an error in your SQL syntax near
[unreadable]

The last line of the message is cut off by the "Click the ping host..." message. Note the line breaks above...because the hostname doesn't fit on the first line, the rest of the message is unreadable.

When connecting to "localhost", I get a full error message (because "locahost" fits on the first line). The error there is "You have an error in your SQL syntax near 'interactive_timeout=1000000; at line 1 (code 1064)"

Ping host, as expected, returns nice happy pongs.

How to repeat:
Attempt any connection from my machine. ;-)

Suggested fix:
Fix the SQL syntax error?
[23 Mar 2005 17:42] [ name withheld ]
Same problem;  command-line use (via mysql) is no problem.
MySQL Administrator 1.0.6-beta on Mac OS X 10.3.8 with 
mysql 3.23.58 .

Error text includes: 

 "... error in your SQL syntax near 'interactive_timeout=1000000' at line 1 (code 1064)"

Also there appears to be a problem with parsing of hostnames from NetInfo - if an entry includes hostname variations (eg "hostname hostname.local") the lookup fails as it appears Administrator is using the entire string instead of parsing it.