Question
Change mysql sql mode
i have mysql installed and table created. i want to remove stricttranstables from sql mode, how to do that? I tried the fonllowing: 1) go to phpmyadmin variable and edit sql mode, but mysql reset it back to default value
2) followed https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-setting and tried in command line to reset sql mode:
sudo mysqld --sql mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
my command line went frozen!?
3) located file /etc/mysql/my.cnf
and tried to change setting there, but didn’t find any sql mode info.
Can i change sql mode after installation? how?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
Thank you so much dinnysingh. Fix to mysqld.cnf worked!! Have been on this problem for two days and all answers regarding previous versions of UBUNTU do not work. ianm