Introduction
To ensure compatibility with your applications, you may need to change the SQL configuration.
Procedure
WHM
In cPanel v102, we added the "SQL Configuration" interface, allowing you to adjust many common MySQL values.
To access this interface, log into WHM, then navigate to "SQL Configuration" using the search bar.
Command-Line
Alternatively, you can edit my.cnf via SSH or WHM >> Terminal. Log into your server as root, then use your favorite text editor to open the file.
nano /etc/my.cnf
[mysqld]
...
sql-mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
Save this file, then restart the SQL service.
/scripts/restartsrv_mysql