mysql - How to fix `unknown variable 'sql-mode=ANSI'`? -


using mysql 5.5.27, in my.cnf have:

[mysql] sql_mode=ansi

upon starting mysql console get:

unknown variable 'sql-mode=traditional'

the mysql doc server sql modes shows option, why not work?

(if helps, on osx lion)

also, here pastebin showing things person has tried, no solution.

i'm pretty reason isn't working because argument mysqld , not client. came alternative way instead. edit users my.cnf i.e. ~/.my.cnf this: 

[client] init-command="set sql_mode='traditional'"

Comments

Post a Comment

Popular posts from this blog

Java sticky instances of class com.mysql.jdbc.Field aggregating -

i noticed (via jmap+jhat) app leaking storing many instances com.mysql.jdbc.field  class - double checked code make sure closing preparedstatements, find few missing didn't change outcome. - preparedstatement created , closed right away - several others created @ start , reused many times - using org.apache.tomcat.jdbc.pool.datasource connection pool what can cause type of behavior? are closing of preparedstatements / result sets using: preparedstatement stmt (possible assignment here); try { // work prepared statement resultset rs; try { while (rs.next()) ... // process results } { rs.close(); } } { stmt.close(); } so guarantee result sets closed when finished (regardless of exceptions) , statements closed (regardless of exceptions)? there other ways write that, idea same. if you're doing of properly, unless have many references it's taking inordinate amount of memory, it's ok , nothing needs done it.
Read more