CentosControl PanelCWPHestia CPMySQLUbuntuVesta CP

How to Disable MySQL Strict Mode CWP/Centos/Ubuntu/AlmaLinux

Today we’ll 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:geroup i.e. : mysql:mysql

Sandeep B.

I'm a system admin and php developer and currently working as System Admin In CWP Control panel, expertise in Linux and Windows administration RHEL certified admin.

Related Articles


Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button