Disabling MySQL Strict Mode

[Kalan]

I'm attempting to disable MySQL strict mode on my database by using this query:
SET @@global.sql_mode= '';

but I receive this error: #1227 - Access denied; you need the SUPER privilege for this operation

I've read that you can also edit a file, but I'm not seeing this file in my directory structure:

Open your "my.ini" file within the MySQL installation directory, and look for the text "sql-mode".
Find:
Code:

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Replace with:
Code:

# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Thanks.

[Edge100x]

You can't change global variables or the global .ini file. Try setting it on a session basis instead:

SET @@SESSION.sql_mode= '';