1. Find mysqld
$ which mysqld /usr/sbin/mysqld
2. Find the location of my.cnf
$ /usr/sbin/mysqld --verbose --help | grep -A 1 'Default options' /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
3. Use vim to open /etc/my.cnf
$ vim /etc/my.cnf
4. Modify the configuration , just delete STRICT_TRANS_TABLES
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
If not, just add it directly
sql_mode=NO_ENGINE_SUBSTITUTION
5. Restart mysql
$ service mysqld restart
After modification, if there are some prompts, like:
ERROR 1364 (HY000): Field 'name' doesn't have a default value
will not prompt.
Recommended: "mysql video tutorial"
The above is the detailed content of About removing strict mode from mysql under linux. For more information, please follow other related articles on the PHP Chinese website!