Re: sql mode in server variables different from options file

[David Meinert]

>> Where is the my.ini file located?


"C:\Program Files (x86)\MySQL\MySQL Server 5.6"


>> Is that the location that mysql is looking in?

yes

>> (Can you find the mysqld command that was executed.)

the sql command that set the sql mode? I have two. one in the options file, and another I run before I try to open the database.

1.
basedir="C:\Program Files (x86)\MySQL\MySQL Server 5.6"
sql-mode = "ANSI"

2.
set GLOBAL sql_mode = 'ANSI';
SELECT @@global.sql_mode, @@session.sql_mode, @@sql_mode;

thank you,

David