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:Mac OS X (Mac OS 10.3.9)
Assigned to: CPU Architecture:Any

[7 Jun 2005 23:39] Chris
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:
?
[8 Jun 2005 5:20] Jorge del Conde
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
[8 Jun 2005 18:32] Nathan Vack
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.
[8 Jun 2005 18:51] Chris
Sorry for the ommission. MySQL 4.0.17-standard.
[10 Jun 2005 15:08] Jorge del Conde
Thanks for your bug report.  I was able to reproduce this connecting to 4.0.18
[15 Jun 2005 17:36] Alfredo Kojima
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/