Welcome to Star License originals. Today lets learn how you can disable mysql strict mode in any server.
- Log in to WHM as the root user and go to Server Configuration >> Terminal.
- Open the MySQL configuration file using your preferred text editor (for example,
nano
orvi
). For cPanel servers, this is the/etc/my.cnf
file we recommend you to use nano. To install nano in centos 7 or almalinux simply type yum install nano -y - Then in your terminal type: nano -w /etc/my.cnf
- Scroll down and paste sql_mode=
Then simply save the file if you dont have a knowledge about nano file modification simply you will get it in google/youtube(Recommended)
Get cheap cPanel License