Jump to content

Recommended Posts

learn how you can easily disable mysql strict mode in MySQL/MariaDB Server on any Linux os such as Centos/Ubuntu/RHEL/AlmaLinux and in Linux Server Control panel like CWP, HestiaCP etc.

Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE. A value can be invalid for several reasons. 

To Disable MySQL strict mode simply add below config in my.cnf usually in /etc/my.cnf ensure you added it under [mysqld] section see example below in this tutorial :


How to find the my.cnf ? mostly my.cnf is located in this locations :



if there is no my.cnf files then create one in this location /etc/my.cnf with below config :

# This group is read both by the client and the server
# use it for options that affect everything


# include *.cnf from the config directory
!includedir /etc/my.cnf.d

**please note you need to change the permission if you’ve newly created the my.cnf to user:group i.e. : mysql:mysql

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...