• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 771
  • Last Modified:

MySQL 5.1 Change mode to Strict Mode

How can you change MySQL 5.1 Change mode to Strict Mode once already installed
0
cybersharks1
Asked:
cybersharks1
  • 3
  • 3
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Open your relevant "my.ini" file, and look for the text "sql-mode"

if the config line contains STRICT_TRANS_TABLES, remove that part, save, and restart mysql
0
 
cybersharks1Author Commented:
Will this change anything, or what is the basic difference.  When installing 5.1 by default does it not turn into strict mode?

We had 4.1 and upgraded and the customer is now saying that we must change it back to strict mode.

But we never change it in 4.1 in the first place.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
cybersharks1Author Commented:
Hi Angell,
  Thanks for the help, so removing STRICT_TRANS_TABLES, from the INI turn mySQL 5.1 into strict mode correct?  Sorry, this is all new to me.  Thank you for your time, I'm still reading a lot on the previous link to better understand
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
no, you need to ADD that setting to make it strict... it's not strict by default.
0
 
cybersharks1Author Commented:
Hi Angell,
  Ok I'm sorry.  I understand the technical statement.  My first question should have been how to disable strict mode.  

So once I got into my.ini file I could see that line   STRICT_TRANS_TABLES so It was already set to strict mode.  So I deleted that part.  Restarted Services and now testing my app again.  I understand how to enable/disable now.  I just need to test and again thanks for the help, I will send you the points.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now