Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    Oct 2015
    Location
    US
    Posts
    176

    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:
    Code:
    sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
    ServerPoint.com, hosting thousands of customers since 1998
    Dedicated Server Hosting - Cloud VPS Hosting - Web Hosting
    Las Vegas / Silicon Valley / Dallas / Ashburn / Amsterdam / Singapore

  2. #2
    Member
    Join Date
    Sep 2020
    Posts
    43
    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 forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.