Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    Oct 2015

    Change MySQL Strict Mode

    If MysQL mode is in strict and some commands aren't going through. This mode enforces very explicit restrictions on the data and format of data that goes into the table columns

    To turn off strict mode in MySQL, edit the my.ini or my.cnf file

    change the sql-mode line to:
    sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION", hosting thousands of customers since 1998
    Dedicated Server Hosting - Cloud VPS Hosting - Web Hosting
    Las Vegas / Silicon Valley / Dallas / Ashburn / Amsterdam / Singapore

  2. #2
    Join Date
    Sep 2020
    You can edit my.cnf or also you can do this from PHPMyadmin.
    You can check steps to edit my.cnf here.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting

Premium Partners:

Visit to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.