You can easily disable MySQL strict mode on Server by following the steps given below.
  • 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.
That's It !
To learn more detail about the steps check out the blog.
Was this answer helpful? 0 Users Found This Useful (0 Votes)