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:
Quote:
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.
Login
Register
FAQ
Search
