How to edit the MySQL/MariaDB configuration (my.cnf) file

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