How to Disable MySQL Strict Mode on Server?

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.
  • disable harden mode using my.cnf file in ssh, disable mysql strict mode, disable strict mode using LInux commands, disable strict mode via my.cnf file, disable strict mode using basic linux commands, disable strict mode from sql, disable strict mode in server, disable strict mode via SSH, inactive mysql strict mode, inhance website security, mysql strict mode, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION, strict mysql mode, turn off strict mode in server, website security strict
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What are some Basic SSH commands?

List of some basic SSH commands are: ls – This command is used to list all files and...

How to connect to SSH?

Putty is an open-source SSH client used to connect to a remote server. This article describes how...

20 Basic Linux Commands and their Uses.

Following are the top 20 basic Linux Commands with Live Examples that would definitely help you...

How to Block/Unblock IPs from SSH?

You can easily block or unblock IPs  from SSH. #1. Block An IP Address from SSH First of all,...

How to install CpCleaner in cPanel through SSH?

CpCleaner is a cPanel plugin created to give cPanel users the option to clean junk files that...