MySql variables

Syntax

      --variable-name=value
andbooleanoptions{FALSE|TRUE} Value(afterreadingoptions)
auto-rehash TRUE
character-sets-dir (Nodefaultvalue)
column-type-info FALSE
comments FALSE
compress FALSE
debug-check FALSE
debug-info FALSE
database (Nodefaultvalue)
default-character-set latin1
delimiter ;
vertical FALSE
force FALSE
named-commands FALSE
ignore-spaces FALSE
local-infile FALSE
no-beep FALSE
host (Nodefaultvalue)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 0
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
shared-memory-base-name (Nodefaultvalue)
socket (Nodefaultvalue)
ssl FALSE
ssl-ca (Nodefaultvalue)
ssl-capath (Nodefaultvalue)
ssl-cert (Nodefaultvalue)
ssl-cipher (Nodefaultvalue)
ssl-key (Nodefaultvalue)
ssl-verify-server-cert FALSE
table FALSE
user (Nodefaultvalue)
safe-updates FALSE
i-am-a-dummy FALSE
connect_timeout 0
max_allowed_packet 16777216
net_buffer_length 16384
select_limit 1000
max_join_size 1000000
secure-auth FALSE
show-warnings FALSE

Related:

MySQL command line


 
Copyright © 1999-2021 SS64.com
Some rights reserved