MySQL Bugs: #11149: No connection possible, unknown sys var sql

Bug #11149	No connection possible, unknown sys var sql_mode (1193)
Submitted:	7 Jun 2005 23:39	Modified:	15 Jun 2005 17:36
Reporter:	Chris	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S1 (Critical)
Version:	1.0.2-alpha	OS:	MacOS (Mac OS 10.3.9)
Assigned to:		CPU Architecture:	Any

Description:
Unable to connect to local MySQL instance. Nothing exotic in configuration. Attempted connection to localhost:3306 user/pass results in Connection Error: Could not connect [...] Error: Unknown system variable 'sql_mode' (code 1193). I have not specifically set sql_mode to anything. MySQL Administrator reports the value as "" (empty). FYI, MySQL Administrator has no problem connecting.

I also attemtped a connection with bad user/pass and got the appropriate "access denied" message. 

System: Mac OS 10.3.9; Dual 1.25 GHz G4; 1.25 GB RAM

How to repeat:
Launch Query Browser; connection dialog appears; enter server hostname (localhost or 127.0.0.1); leave port (3306); username (xxxx); password (yyyy); and connect. Error message results: Connection Error: Could not connect [...] Error: Unknown system variable 'sql_mode' (code 1193). 'sql_mode' is unset in my environment (default).

Suggested fix:
?

Hi,

Can you tell me what version of MySQL are you connecting to ?

Regarding sql_mode, you can read more about it here:

http://dev.mysql.com/doc/mysql/en/server-sql-mode.html

Thanks

I'm getting this, too, when connecting to:

4.0.18-standard, on Redhat linux / i386

4.0.20-standard-log on sun-solaris2.9

Both are stock MySQL-provided binaries.

Sorry for the ommission. MySQL 4.0.17-standard.

Thanks for your bug report.  I was able to reproduce this connecting to 4.0.18

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/