- Log in to SSH using root credentials.
- Navigate to the /etc directory and open my.cnf file using the vi or nano command.
- Find the sql_mode = “” line and type the below command inside the double quotes ( ” ” ).
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
- Press Esc from your keyboard and type :wq to save and exit.
- Restart MySQL Server using the service mysql restart command.
To learn more detail about the steps check out the blog.