在 windows 下,进入 CMD 窗口,打开至 bin 目录,对 mysqld.exe 进行命令操作:mysqld --verbose --help
可以看到一大堆系统的设置的: --abort-slave-event-count=#
Option used by mysql-test for debugging and testing of
replication.
--allow-suspicious-udfs
Allows use of UDFs consisting of only one symbol xxx()
without corresponding xxx_init() or xxx_deinit(). That
also means that one can load any function from any
library, for example exit() from libc.so
-a, --ansi Use ANSI SQL syntax instead of MySQL syntax. This mode
will also set transaction isolation level 'serializable'.
--archive[=name] Enable or disable ARCHIVE plugin. Possible values are ON,
OFF, FORCE (don't start if the plugin fails to load).
--auto-increment-increment[=#]
Auto-increment columns are incremented by this
--auto-increment-offset[=#]
Offset added to Auto-increment columns. Used when
auto-increment-increment != 1
..................然后下面就是详细的参数情况:
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
------------------------------------------------- ------------------------
abort-slave-event-count 0
allow-suspicious-udfs FALSE
archive ON
auto-increment-increment 1
auto-increment-offset 1
autocommit TRUE
automatic-sp-privileges TRUE
back-log 50..............
那么我要如何修改这些设置呢?比如我想修改 allow-suspicious-udfs 这个选项,想将它设置为 TRUEmysqlfunctioncmd
可以看到一大堆系统的设置的: --abort-slave-event-count=#
Option used by mysql-test for debugging and testing of
replication.
--allow-suspicious-udfs
Allows use of UDFs consisting of only one symbol xxx()
without corresponding xxx_init() or xxx_deinit(). That
also means that one can load any function from any
library, for example exit() from libc.so
-a, --ansi Use ANSI SQL syntax instead of MySQL syntax. This mode
will also set transaction isolation level 'serializable'.
--archive[=name] Enable or disable ARCHIVE plugin. Possible values are ON,
OFF, FORCE (don't start if the plugin fails to load).
--auto-increment-increment[=#]
Auto-increment columns are incremented by this
--auto-increment-offset[=#]
Offset added to Auto-increment columns. Used when
auto-increment-increment != 1
..................然后下面就是详细的参数情况:
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
------------------------------------------------- ------------------------
abort-slave-event-count 0
allow-suspicious-udfs FALSE
archive ON
auto-increment-increment 1
auto-increment-offset 1
autocommit TRUE
automatic-sp-privileges TRUE
back-log 50..............
那么我要如何修改这些设置呢?比如我想修改 allow-suspicious-udfs 这个选项,想将它设置为 TRUEmysqlfunctioncmd
2.永久生效,写入配置文件。
--allow-suspicious-udfs1个是用SET另外是用MYSQLD --allow-suspicious-udfs
来设置
或者在 my.ini 文件中设置 allow-suspicious-udfs=true 来实现。估计是MY.ini文件没正确设置。
"D:\MySQL55\bin\mysqld" --defaults-file="D:\MySQL55\my.ini " --allow-suspicious-udfs=true
是 false 的 ,我知道你的意思,输出设定表可是不行
MY.INI [mysqld] allow-suspicious-udfs=TRUEmysqld --verbose --help >123.TXT.....
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
------------------------------------------------- ------------------------
abort-slave-event-count 0
allow-suspicious-udfs TRUE
archive ON
auto-increment-increment 1
auto-increment-offset 1
autocommit TRUE
automatic-sp-privileges TRUE
.....