Linux CentOS 上的 Mysql 模式

Question

我在 CentOS Linux 上安装了 Mysql 5.6默认情况下它设置 SQl 模式严格

 SELECT @@GLOBAL.sql_mode;+--------------------------------------------+| @@GLOBAL.sql_mode                          |+--------------------------------------------+| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | SELECT @@SESSION.sql_mode;+--------------------------------------------+| @@SESSION.sql_mode                         |+--------------------------------------------+| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |+--------------------------------------------+

我通过命令行将 sql_mode 从 root 用户更改为无通过命令

SET SESSION sql_mode = '';SET GLOBAL sql_mode = '';

在此之后，我执行了上面的命令，它们显示了

 SELECT @@SESSION.sql_mode;+--------------------+| @@SESSION.sql_mode |+--------------------+|                    |+--------------------+1 row in set (0.00 sec)mysql> SELECT @@GLOBAL.sql_mode;+-------------------+| @@GLOBAL.sql_mode |+-------------------+|                   |+-------------------+1 row in set (0.00 sec)

但是当我重新启动 Mysql Server 时，我再次设置严格模式，即

 SELECT @@GLOBAL.sql_mode;+--------------------------------------------+| @@GLOBAL.sql_mode                          |+--------------------------------------------+| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | SELECT @@SESSION.sql_mode;+--------------------------------------------+| @@SESSION.sql_mode                         |+--------------------------------------------+| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |+--------------------------------------------+

我还在 my.cnf 文件中添加了 mysql-mode=""但重新启动 mysql 后结果相同

Answer 1

添加到您的 my.cnf 文件中:

sql_mode = ""

然后重启mysql

它应该是这样的:

user        = nobody
port        = 3306
socket      = /opt/lampp/var/mysql/mysql.sock
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
open_files_limit = 50k
sql_mode = ""