Bug #11265 Can't connect to local MySQL: unknown system variable 'sql_mode'
Submitted: 12 Jun 2005 5:22 Modified: 13 Jul 2005 9:57
Reporter: Rob Lewis (Candidate Quality Contributor) Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.0.21 OS:MacOS (OS X Server 10.3.9)
Assigned to: CPU Architecture:Any

[12 Jun 2005 5:22] Rob Lewis
Can't connect to localhost; get message "Error: unknown system variable 'sql_mode' (code 1193)"

How to repeat:
Try to log in as root to a local copy of MySQL
[13 Jun 2005 9:57] Aleksey Kishkin
Rob, what the version of mysql do you use?
[15 Jun 2005 14:59] Xavier Destombes
I have the exact same problem here, using OS X Tiger 10.4.1, MySQL 4.0.24 (MySQL distribution).
I didn't do anything to the config file. I only password protected the root account...
[16 Jun 2005 6:24] Xavier Destombes
Fixed in 1.0.22.
[12 Jul 2005 23:10] jean claude clariond
linux:/home/lavercq # mysql --user=root mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
What can I do ?
[13 Jul 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".