All Categories
Recently Viewed
[Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.
Home » Categories » MySQL » Configuration

How do I disable Strict Mode in MySQL?
Article Number: 37 | Rating: Unrated | Last Updated: Mon, Sep 28, 2020 at 1:49 AM
  1. Look for the following line:
    sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  2. Change it to:
    sql-mode="" (Blank)
  3. Restart the MySQL Service.

 

Reference:

https://www.knowledgebase-script.com/kb/article/how-do-i-disable-strict-mode-in-mysql-163.html
Posted by: Saeed Nobakht - Mon, Sep 28, 2020 at 1:49 AM This article has been viewed 810 times.
Filed Under: Configuration
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
 
Attachments Attachments
There are no attachments for this article.
Comments Comments
There are no comments for this article. Be the first to post a comment.
Icon Add Comment
Name
Email (Required, but not published)
Comment
Security Code Security Code
 
Related Articles RSS Feed
Your Password does not satisfy the Current Policy Requirements
Viewed 720 times since Sat, Sep 19, 2020
MySQL/MariaDB error on the server with Plesk: Could not increase number of max_open_files to more than 16384
Viewed 279 times since Sun, Aug 24, 2025
How can I disable MySQL Strict Mode?
Viewed 947 times since Mon, Sep 28, 2020
SHOW VARIABLES Statement
Viewed 752 times since Sun, Sep 27, 2020
MySQL-PHP get and echo NOW() value?
Viewed 750 times since Mon, Sep 28, 2020
How to change the MySQL root account password on CentOS7?
Viewed 691 times since Sat, Sep 5, 2020
[Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.
Viewed 2165 times since Sun, Sep 27, 2020
How to enable explicit_defaults_for_timestamp?
Viewed 1178 times since Sun, Sep 27, 2020
Subscribe to knowledgebase
Get notified when new articles are added to the knowledgebase.