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
Comments
0 comments
Please sign in to leave a comment.