With the recent AutoSSL issues and the US holiday, we are currently experiencing a higher than usual ticket volume and as a result there may be delays before we can reply to your ticket. Please feel free to reference the information available in our Forums, Documentation, and Knowledge Base in the meantime and we thank you in advance for your continued patience.

Skip to main content

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

Alex Jankowiak
  • Updated

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

Related articles

Comments

0 comments

Article is closed for comments.