Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How To Disable MySQL Strict Mode
Thumbs Up 
[Image: MySQL-Database.jpg]
In this tutorial we will show you how to disable MySQL strict mode on your CentOS 7 server. For those of you who didn’t know, Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE. A value can be invalid for several reasons.This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step turn off or to disable the MySQL strict mode on a CentOS 7 server.

Open the file with your favorite command line editor. In this example, we use ‘nano’:
nano /etc/my.cnf

Find the following lines:

If you find a line similar to the above that is setting the 
variable then you will need to replace it with the following line to disable MySQL strict mode:

Finally, Restart MySQL with this command:
systemctl restart mysql

To verify that the process was completed properly you can run the following:
mysql -e "SELECT @@sql_mode;"

The output may look similar to the following:
| @@sql_mode

Congratulation’s! You have successfully disable the MySQL strict mode. Thanks for using this tutorial for turn off or to disable the MySQL strict mode on CentOS 7 system. For additional help or useful information, we recommend you to check the official MySQL web site.
[Image: logo.png]
Cheapest web hosting starting with the lowest price of $ 0.5

Forum Jump:

Users browsing this thread: 1 Guest(s)