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

The fastest way to edit my.cnf is via SSH. 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