`
isiqi
  • 浏览: 15946704 次
  • 性别: Icon_minigender_1
  • 来自: 济南
社区版块
存档分类
最新评论

mysql --help (DOS下mysql可以使用的选项;其他如mysqladmin, mysqldump也可以--help获取帮助)

阅读更多
mysql Ver 14.12 Distrib 5.0.45, for Win32 (ia32)
Copyright (C) 2002 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Usage: mysql [OPTIONS] [database]

-?, --help Display this help and exit.
//获取帮助
-I, --help Synonym for -?

--auto-rehash Enable automatic rehashing. One doesn't need to use
'rehash' to get table and field completion, but startup
and reconnecting may take a longer time. Disable with
--disable-auto-rehash.
-A, --no-auto-rehash
No automatic rehashing. One has to use 'rehash' to get
table and field completion. This gives a quicker start of
mysql and disables rehashing on reconnect. WARNING:
options deprecated; use --disable-auto-rehash instead.
-B, --batch Don't use history file. Disable interactive behavior.
(Enables --silent)

--character-sets-dir=name
Directory where character sets are.

--default-character-set=name
Set the default character set.
//设置字符集


-C, --compress Use compression in server/client protocol.
-#, --debug[=#] This is a non-debug version. Catch this and exit

-D, --database=name Database to use.
//mysql之后使用该命令,连接server之后直接使用指定<wbr></wbr>的database <!-- D(["mb","\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n --delimiter\u003dname Delimiter to be used.\u003cbr\>//sql返回结果使用的分隔符\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003c/span\>\u003cbr\>\u003cbr\> -e, --execute\u003dname Execute command and quit. (Disables --force and history\u003cbr\> file)\n\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> -E, --vertical Print the output of a query (rows) vertically.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n//垂直列表输出查询结果,默认为表格形式\u003c/span\>\u003cbr\>\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> -f, --force Continue even if we get an sql error.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n//强制执行,忽略错误\u003c/span\>\u003cbr\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> -G, --named-commands \u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n Enable named commands. Named commands mean this program&#39;s\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> internal commands; see mysql&gt; help . When enabled, the\n\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> named commands can be used from any line of the query,\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\n\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> otherwise only from the first line, before an enter.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n Disable with --disable-named-commands. This option is\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> disabled by default.\n\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>",1] ); //-->

--delimiter=name Delimiter to be used.
//sql返回结果使用的分隔符


-e, --execute=name Execute command and quit. (Disables --force and history
file)

-E, --vertical Print the output of a query (rows) vertically.
//垂直列表输出查询结果,默认为表格形式


-f, --force Continue even if we get an sql error.
//强制执行,忽略错误

-G, --named-commands
Enable named commands. Named commands mean this program's
internal commands; see mysql> help . When enabled, the
named commands can be used from any line of the query,
otherwise only from the first line, before an enter.
Disable with --disable-named-commands. This option is
disabled by default.
<!-- D(["mb","//named-commands只是mysql\u003cWBR\>&gt;可以输入的命令,mysql&gt;help可以查看到\u003c/span\>\u003cbr\>\u003cbr\> -g, --no-named-commands \u003cbr\> Named commands are disabled. Use \\* form only, or use\n\u003cbr\> named commands only in the beginning of a line ending\u003cbr\> with a semicolon (;) Since version 10.9 the client now\u003cbr\> starts with this option ENABLED by default! Disable with\n\u003cbr\> &#39;-G&#39;. Long format commands still work from the first\u003cbr\> line. WARNING: option deprecated; use\u003cbr\> --disable-named-commands instead.\u003cbr\>\u003cbr\>\u003cbr\> -i, --ignore-spaces Ignore space after function names.\n\u003cbr\>\u003cbr\> --local-infile Enable/disable LOAD DATA LOCAL INFILE.\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> -b, --no-beep Turn off beep on error.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\n\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//关闭错误提示声音,这个比较有趣\u003c/span\>\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> -h, --host\u003dname Connect to host.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\n\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//连接主机,默认为localhost\u003c/span\>\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> -H, --html Produce HTML output.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\n\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//查询输出结果自动为HTML格式\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> -X, --xml Produce XML output\u003c/span\>\n\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//查询输出结果自动生成为XML格式,如果查询结果要应用到其他\u003cWBR\>程序中,使用该选项将很有用,不需要在自己构造XML文件了\u003c/span\>\u003cbr\>\u003cbr\>\u003cbr\> --line-numbers Write line numbers for errors.\n\u003cbr\> -L, --skip-line-numbers \u003cbr\> Don&#39;t write line number for errors. WARNING: -L is\u003cbr\> deprecated, use long version of this option instead.\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>",1] ); //--> //named-commands只是mysql<wbr></wbr>>可以输入的命令,mysql>help可以查看到

-g, --no-named-commands
Named commands are disabled. Use \* form only, or use
named commands only in the beginning of a line ending
with a semicolon (;) Since version 10.9 the client now
starts with this option ENABLED by default! Disable with
'-G'. Long format commands still work from the first
line. WARNING: option deprecated; use
--disable-named-commands instead.


-i, --ignore-spaces Ignore space after function names.

--local-infile Enable/disable LOAD DATA LOCAL INFILE.

-b, --no-beep Turn off beep on error.
//关闭错误提示声音,这个比较有趣

-h, --host=name Connect to host.
//连接主机,默认为localhost

-H, --html Produce HTML output.
//查询输出结果自动为HTML格式
-X, --xml Produce XML output
//查询输出结果自动生成为XML格式,如果查询结果要应用到其他<wbr></wbr>程序中,使用该选项将很有用,不需要在自己构造XML文件了


--line-numbers Write line numbers for errors.
-L, --skip-line-numbers
Don't write line number for errors. WARNING: -L is
deprecated, use long version of this option instead.

<!-- D(["mb","\n -n, --unbuffered Flush buffer after each query.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//使用MySQL查询的时候,如果连续两次执行同一条SELEC\u003cWBR\>T语句,会发现第二次比第一次速度快,这是因为MySQL对每次查\u003cWBR\>询会缓存,该选项即是每次查询之后摸去缓存。\n\u003c/span\>\u003cbr\>\u003cbr\> --column-names Write column names in results.\u003cbr\> -N, --skip-column-names \u003cbr\> Don&#39;t write column names in results. WARNING: -N is\u003cbr\> deprecated, use long version of this options instead.\n\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> -O, --set-variable\u003dname \u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> Change the value of a variable. Please note that this\n\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> option is deprecated; you can set variables directly with\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\n\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> --variable-name\u003dvalue.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//该选项不赞成使用\u003c/span\>\n\u003cbr\>\u003cbr\> --sigint-ignore Ignore SIGINT (CTRL-C)\u003cbr\> -o, --one-database Only update the default database. This is useful for\u003cbr\> skipping updates to other database in the update log.\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n -p, --password[\u003dname] \u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> Password to use when connecting to server. If password is\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\n\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> not given it&#39;s asked from the tty.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n//用户密码\u003c/span\>\u003cbr\>\u003cbr\> -W, --pipe Use named pipes to connect to server.",1] ); //--> -n, --unbuffered Flush buffer after each query.
//使用MySQL查询的时候,如果连续两次执行同一条SELEC<wbr></wbr>T语句,会发现第二次比第一次速度快,这是因为MySQL对每次查<wbr></wbr>询会缓存,该选项即是每次查询之后摸去缓存。

--column-names Write column names in results.
-N, --skip-column-names
Don't write column names in results. WARNING: -N is
deprecated, use long version of this options instead.

-O, --set-variable=name
Change the value of a variable. Please note that this
option is deprecated; you can set variables directly with
--variable-name=value.
//该选项不赞成使用

--sigint-ignore Ignore SIGINT (CTRL-C)
-o, --one-database Only update the default database. This is useful for
skipping updates to other database in the update log.

-p, --password[=name]
Password to use when connecting to server. If password is
not given it's asked from the tty.
//用户密码

-W, --pipe Use named pipes to connect to server. <!-- D(["mb","\u003cbr\> -P, --port\u003d# Port number to use for connection.\u003cbr\>\u003cbr\> --prompt\u003dname Set the mysql prompt to this value.\u003cbr\> --protocol\u003dname The protocol of connection (tcp,socket,pipe,memory).\n\u003cbr\> -q, --quick Don&#39;t cache result, print it row by row. This may slow\u003cbr\> down the server if the output is suspended. Doesn&#39;t use\u003cbr\> history file.\u003cbr\> -r, --raw Write fields without conversion. Used with --batch.\n\u003cbr\>\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> --reconnect Reconnect if the connection is lost. Disable with\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n --disable-reconnect. This option is enabled by default.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//自动重新连接Server\u003c/span\>\u003cbr\>\u003cbr\> -s, --silent Be more silent. Print results with a tab as separator,\n\u003cbr\> each row on new line.\u003cbr\> --shared-memory-base-name\u003dname \u003cbr\> Base name of shared memory.\u003cbr\> -S, --socket\u003dname Socket file to use for connection.\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n --ssl Enable SSL for connection (automatically enabled with\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> other flags). Disable with --skip-ssl.\n\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//开启ssl\u003c/span\>\u003cbr\>\u003cbr\> --ssl-ca\u003dname CA file in PEM format (check OpenSSL docs, implies\u003cbr\> --ssl).\n\u003cbr\> --ssl-capath\u003dname CA directory (check OpenSSL docs, implies --ssl).\u003cbr\> --ssl-cert\u003dname X509 cert in PEM format (implies --ssl).\u003cbr\> --ssl-cipher\u003dname SSL cipher to use (implies --ssl).\u003cbr\> --ssl-key\u003dname X509 key in PEM format (implies --ssl).\n\u003cbr\> --ssl-verify-server-cert \u003cbr\>",1] ); //-->
-P, --port=# Port number to use for connection.

--prompt=name Set the mysql prompt to this value.
--protocol=name The protocol of connection (tcp,socket,pipe,memory).
-q, --quick Don't cache result, print it row by row. This may slow
down the server if the output is suspended. Doesn't use
history file.
-r, --raw Write fields without conversion. Used with --batch.


--reconnect Reconnect if the connection is lost. Disable with
--disable-reconnect. This option is enabled by default.
//自动重新连接Server

-s, --silent Be more silent. Print results with a tab as separator,
each row on new line.
--shared-memory-base-name=name
Base name of shared memory.
-S, --socket=name Socket file to use for connection.

--ssl Enable SSL for connection (automatically enabled with
other flags). Disable with --skip-ssl.
//开启ssl

--ssl-ca=name CA file in PEM format (check OpenSSL docs, implies
--ssl).
--ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).
--ssl-cert=name X509 cert in PEM format (implies --ssl).
--ssl-cipher=name SSL cipher to use (implies --ssl).
--ssl-key=name X509 key in PEM format (implies --ssl).
--ssl-verify-server-cert
<!-- D(["mb"," Verify server&#39;s &quot;Common Name&quot; in its cert against\u003cbr\> hostname used when connecting. This option is disabled by\u003cbr\> default.\n\u003cbr\>\u003cbr\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> -t, --table Output in table format.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n//结果以表格形式输出\u003c/span\>\u003cbr\>\u003cbr\> -T, --debug-info Print some debug info at exit.\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> --tee\u003dname Append everything into outfile. See interactive help (\\h)\u003c/span\>\n\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> also. Does not work in batch mode. Disable with\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\n\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> --disable-tee. This option is disabled by default.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n --no-tee Disable outfile. See interactive help (\\h) also. WARNING:\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\> option deprecated; use --disable-tee instead\n\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//进入mysql之后执行的所有命令和返回结果都输出到指定的外\u003cWBR\>部文件中outfile,取消输出用--no-tee\u003c/span\>\u003cbr\>\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\n -u, --user\u003dname User for login if not current user.\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//用户名\u003c/span\>\u003cbr\>\u003cbr\>\u003cbr\> -U, --safe-updates Only allow UPDATE and DELETE that uses keys.\n\u003cbr\> -U, --i-am-a-dummy Synonym for option --safe-updates, -U.\u003cbr\> -v, --verbose Write more. (-v -v -v gives the table output format).\u003cbr\>\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>",1] ); //--> Verify server's "Common Name" in its cert against
hostname used when connecting. This option is disabled by
default.


-t, --table Output in table format.
//结果以表格形式输出

-T, --debug-info Print some debug info at exit.

--tee=name Append everything into outfile. See interactive help (\h)
also. Does not work in batch mode. Disable with
--disable-tee. This option is disabled by default.
--no-tee Disable outfile. See interactive help (\h) also. WARNING:
option deprecated; use --disable-tee instead
//进入mysql之后执行的所有命令和返回结果都输出到指定的外<wbr></wbr>部文件中outfile,取消输出用--no-tee


-u, --user=name User for login if not current user.
//用户名


-U, --safe-updates Only allow UPDATE and DELETE that uses keys.
-U, --i-am-a-dummy Synonym for option --safe-updates, -U.
-v, --verbose Write more. (-v -v -v gives the table output format).


<!-- D(["mb"," -V, --version Output version information and exit.\n\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>//显示MySQL版本信息\u003c/span\>\u003cbr\>\u003cbr\> -w, --wait Wait and retry if connection is down.\u003cbr\> --connect_timeout\u003d# Number of seconds before connection timeout.\n\u003cbr\> --max_allowed_packet\u003d# \u003cbr\> Max packet length to send to, or receive from server\u003cbr\> --net_buffer_length\u003d# \u003cbr\> Buffer for TCP/IP and socket communication\u003cbr\> --select_limit\u003d# Automatic limit for SELECT when using --safe-updates\n\u003cbr\> --max_join_size\u003d# Automatic limit for rows in a join when using\u003cbr\> --safe-updates\u003cbr\> --secure-auth Refuse client connecting to server if it uses old\u003cbr\> (pre-4.1.1\n) protocol\u003cbr\> --show-warnings Show warnings after every statement.\u003cbr\>\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 204, 204)\"\>//如下显示了MySQL的默认选项,Windows下MySQL的默认选项都保存在my.ini,根据如下的顺序,用户可以修改my.ini,从而修改MySQL的配置信息,改变MySQL的性能。\n\u003c/span\>\u003cbr\>\u003cbr\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>Default options are read from the following files in the given order:\u003c/span\>\u003cbr style\u003d\"background-color:rgb(255, 255, 153)\"\>\u003cspan style\u003d\"background-color:rgb(255, 255, 153)\"\>\nC:\\my.ini C:\\my.cnf C:\\WINDOWS\\my.ini C:\\WINDOWS\\my.cnf C:\\Program Files\\MySQL\\MySQL Server 5.0\\my.ini C:\\Program Files\\MySQL\\MySQL Server 5.0\\my.cnf \u003c/span\>\u003cbr\>\u003cbr\>\u003cbr\>The following groups are read: mysql client\u003cbr\>The following options may be given as the first argument:\n\u003cbr\>--print-defaults Print the program argument list and exit\u003cbr\>--no-defaults Don&#39;t read default options from any options file\u003cbr\>--defaults-file\u003d# Only read default options from the given file #\u003cbr\>--defaults-extra-file\u003d# Read this file after the global files are read\n\u003cbr\>\u003cbr\>Variables (--variable-name\u003dvalue)\u003cbr\>and boolean options {FALSE|TRUE} Value (after reading options)\u003cbr\>------------------------------\u003cWBR\>--- -----------------------------\u003cbr\>auto-rehash",1] ); //--> -V, --version Output version information and exit.
//显示MySQL版本信息

-w, --wait Wait and retry if connection is down.
--connect_timeout=# Number of seconds before connection timeout.
--max_allowed_packet=#
Max packet length to send to, or receive from server
--net_buffer_length=#
Buffer for TCP/IP and socket communication
--select_limit=# Automatic limit for SELECT when using --safe-updates
--max_join_size=# Automatic limit for rows in a join when using
--safe-updates
--secure-auth Refuse client connecting to server if it uses old
(pre-4.1.1 ) protocol
--show-warnings Show warnings after every statement.


//如下显示了MySQL的默认选项,Windows下MySQL的默认选项都保存在my.ini,根据如下的顺序,用户可以修改my.ini,从而修改MySQL的配置信息,改变MySQL的性能。

Default options are read from the following files in the given order:
C:\my.ini C:\my.cnf C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\Program Files\MySQL\MySQL Server 5.0\my.ini C:\Program Files\MySQL\MySQL Server 5.0\my.cnf


The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read

Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
------------------------------
<wbr></wbr>--- -----------------------------
auto-rehash <!-- D(["mb","\u003cWBR\> TRUE\u003cbr\>\ncharacter-sets-dir\u003cWBR\> (No default value)\u003cbr\>default-character-set\u003cWBR\> latin1\u003cbr\>compress\u003cWBR\> FALSE\u003cbr\>database\u003cWBR\> (No default value)\u003cbr\>delimiter\u003cWBR\> ;\n\u003cbr\>vertical\u003cWBR\> FALSE\u003cbr\>force\u003cWBR\> FALSE\u003cbr\>named-commands\u003cWBR\> FALSE\u003cbr\>local-infile\u003cWBR\> FALSE\u003cbr\>no-beep\u003cWBR\> FALSE\u003cbr\>host\u003cWBR\> (No default value)\n\u003cbr\>html\u003cWBR\> FALSE\u003cbr\>xml\u003cWBR\> FALSE\u003cbr\>line-numbers\u003cWBR\> TRUE\u003cbr\>unbuffered\u003cWBR\> FALSE\u003cbr\>column-names\u003cWBR\> TRUE\u003cbr\>sigint-ignore\u003cWBR\> FALSE\n\u003cbr\>port\u003cWBR\> 3306\u003cbr\>prompt\u003cWBR\> mysql&gt; \u003cbr\>quick\u003cWBR\> FALSE\u003cbr\>raw\u003cWBR\> FALSE\u003cbr\>reconnect\u003cWBR\> TRUE\u003cbr\>\nshared-memory-base-name\u003cWBR\> (No default value)\u003cbr\>socket\u003cWBR\> (No default value)\u003cbr\>ssl\u003cWBR\> FALSE\u003cbr\>ssl-ca\u003cWBR\> (No default value)\u003cbr\>ssl-capath\u003cWBR\> (No default value)\n\u003cbr\>ssl-cert\u003cWBR\> (No default value)\u003cbr\>ssl-cipher\u003cWBR\> (No default value)\u003cbr\>ssl-key\u003cWBR\> (No default value)\u003cbr\>ssl-verify-server-cert\u003cWBR\> FALSE\u003cbr\>table\u003cWBR\> FALSE\n\u003cbr\>debug-info\u003cWBR\> FALSE\u003cbr\>user\u003cWBR\> (No default value)\u003cbr\>safe-updates\u003cWBR\> FALSE\u003cbr\>i-am-a-dummy\u003cWBR\> FALSE\u003cbr\>connect_timeout\u003cWBR\> 0\n\u003cbr\>max_allowed_packet\u003cWBR\> 16777216\u003cbr\>net_buffer_length\u003cWBR\> 16384\u003cbr\>select_limit",1] ); //--> <wbr></wbr> TRUE
character-sets-dir<wbr></wbr> (No default value)
default-character-set<wbr></wbr> latin1
compress<wbr></wbr> FALSE
database<wbr></wbr> (No default value)
delimiter<wbr></wbr> ;
vertical<wbr></wbr> FALSE
force<wbr></wbr> FALSE
named-commands<wbr></wbr> FALSE
local-infile<wbr></wbr> FALSE
no-beep<wbr></wbr> FALSE
host<wbr></wbr> (No default value)
html<wbr></wbr> FALSE
xml<wbr></wbr> FALSE
line-numbers<wbr></wbr> TRUE
unbuffered<wbr></wbr> FALSE
column-names<wbr></wbr> TRUE
sigint-ignore<wbr></wbr> FALSE
port<wbr></wbr> 3306
prompt<wbr></wbr> mysql>
quick<wbr></wbr> FALSE
raw<wbr></wbr> FALSE
reconnect<wbr></wbr> TRUE
shared-memory-base-name<wbr></wbr> (No default value)
socket<wbr></wbr> (No default value)
ssl<wbr></wbr> FALSE
ssl-ca<wbr></wbr> (No default value)
ssl-capath<wbr></wbr> (No default value)
ssl-cert<wbr></wbr> (No default value)
ssl-cipher<wbr></wbr> (No default value)
ssl-key<wbr></wbr> (No default value)
ssl-verify-server-cert<wbr></wbr> FALSE
table<wbr></wbr> FALSE
debug-info<wbr></wbr> FALSE
user<wbr></wbr> (No default value)
safe-updates<wbr></wbr> FALSE
i-am-a-dummy<wbr></wbr> FALSE
connect_timeout<wbr></wbr> 0
max_allowed_packet<wbr></wbr> 16777216
net_buffer_length<wbr></wbr> 16384
select_limit <!-- D(["mb","\u003cWBR\> 1000\u003cbr\>max_join_size\u003cWBR\> 1000000\u003cbr\>secure-auth\u003cWBR\> FALSE\u003cbr\>\nshow-warnings\u003cWBR\> FALSE\u003cbr\>\u003cbr\>\n",0] ); D(["ce"]); //--> <wbr></wbr> 1000
max_join_size<wbr></wbr> 1000000
secure-auth<wbr></wbr> FALSE
show-warnings<wbr></wbr> FALSE
分享到:
评论

相关推荐

    linux下mysql的rpm安装包

    一、卸载原来的mysql: 卸载一: 输入: #rpm -qa | grep -i mysql 显示: mysql-libs-5.1.52-1.el6_0.1.i686 ...命令和dos下登录mysql是一样的: # mysql -uroot -p123456 或者 # mysql -uroot -p[回车] 再输入密码

    MySQL 5.6.25 源码包+安装方法 (mysql-5.6.25.tar.gz)

    mysql-5.6.25.tar 包含两个文件: - mysql-5.6.25.tar.gz Generic Linux (Architecture Independent), Compressed TAR Archive MD5: 37664399c91021abe070faa700ecd0ed -install.txt: 安装方法 首先解压mysql-...

    mysql-5.7.26-winx64.zip

    MySQL安装包,Windows64解压缩版。 首先安装这个环境:vcredist_x64 1、添加环境系统变量 MYSQL_HOME D:\Program Files\mysql-5.7.23-winx64 2、编辑path变量,添加MYSQL_HOME:%MYSQL_HOME%\bin 3、新建my.ini文件...

    mysql5.7.19安装包64位rpm格式

    CentOS7默认安装MariaDB而不是MySQL,而且yum服务器上也移除了MySQL相关的软件包。因为MariaDB和MySQL可能会冲突,故先卸载MariaDB。 1、安装新版mysql之前,我们需要将系统自带的mariadb-lib卸载 [root@iZwz94qazh...

    Mysql安装Linux

    一、卸载原来的mysql: 卸载一: 输入: #rpm -qa | grep -i mysql 显示: mysql-libs-5.1.52-1.el6_0.1.i686 ...命令和dos下登录mysql是一样的: # mysql -uroot -p123456 或者 # mysql -uroot -p[回车] 再输入密码

    MYSQL.rar_MYSQL_ROOT_mysql root_root-Cyclic-Music_sql

    读者可以尝试其它所有本章介绍的方法。 4、首先以root用户的身份连接到服务器: shell&gt; mysql -u root -p Enter password:******* 出现Enter password提后输入root用户的密码,然后即进入mysql客户机的交互模式...

    mysql用法小结

    -------------------------- 基本系统操作 -------------------------- windows 系统启动/停止 mysql 服务器 启动: mysql_home\bin\mysqld --console mysql_home\bin\mysqld 停止: ...mysqld --help

    MySQL 入门学习 ——基础教程

    在mysql&gt;提示符下输入quit可以随时退出交互操作界面: mysql&gt; quit Bye 你也可以用control-D退出。 · 4、第一条命令 mysql&gt; select version(),current_date(); +----------------+-----------------+ | ...

    MySQL 5.1参考手册

    3.5. 在批处理模式下使用mysql 3.6. 常用查询的例子 3.6.1. 列的最大值 3.6.2. 拥有某个列的最大值的行 3.6.3. 列的最大值:按组 3.6.4. 拥有某个字段的组间最大值的行 3.6.5. 使用用户变量 3.6.6. 使用外键 3.6.7. ...

    linux下启动mysql服务

    其实提示找不到 /tmp/mysql.sock有时也并不是/tmp目录下没这个文件,是启动 命令不对,我碰到过 常见的几种启动方式,自己也不是记得很清楚,如果你确定tmp下有mysql.sock这 个文件不妨试试另外的几个命令 /usr/...

    Mysql高级-day04.pdf

    mysql相关内容,包括mysql常用工具、mysql日志、mysql主从复制,比如mysqladmin客户端程序,mysqlbinlog日志管理工具、mysqldump客户端工具可以进行数据迁移

    MySql 5.1 参考手册.chm

    3.5. 在批处理模式下使用mysql 3.6. 常用查询的例子 3.6.1. 列的最大值 3.6.2. 拥有某个列的最大值的行 3.6.3. 列的最大值:按组 3.6.4. 拥有某个字段的组间最大值的行 3.6.5. 使用用户变量 3.6.6. 使用外键 3.6.7. ...

    MYSQL使用指南.doc

    但例1增加的用户是十分危险的,你想如某个人知道test1的密码,那么他就可以在internet上的任何一台电脑上登录你的MySQL数据库并对你的数据可以为所欲为了,解决办法见例2。 例2、增加一个用户test2密码为abc,让他只...

    MySQL 5权威指南(第3版) 中文版 下载地址

    以及SQL语法、工具、选项、API应用指南,最大限度地帮助读者更快地学习和掌握MySQL数据库系统的设计和使用。本书覆盖了MySQL 5.0,讨论了新的程序设计接口(如PHP 5里的mysqli)和新的系统管理工具。  本书是MySQL...

    mysql官方中文参考手册

    3.5. 在批处理模式下使用mysql 3.6. 常用查询的例子 3.6.1. 列的最大值 3.6.2. 拥有某个列的最大值的行 3.6.3. 列的最大值:按组 3.6.4. 拥有某个字段的组间最大值的行 3.6.5. 使用用户变量 3.6.6. 使用外键 3.6.7. ...

    MySQL 5.1中文手冊

    3.5. 在批处理模式下使用mysql 3.6. 常用查询的例子 3.6.1. 列的最大值 3.6.2. 拥有某个列的最大值的行 3.6.3. 列的最大值:按组 3.6.4. 拥有某个字段的组间最大值的行 3.6.5. 使用用户变量 3.6.6. 使用外键 3.6.7. ...

    MySQL命令大全

    对于那些已经不用的用户应给予清除,权限过界的用户应及时回收权限,回收权限可以通过更新User表相应字段,也可以使用REVOKE操作。 下面给出本人从其它资料(www.cn-java.com)获得的对常用权限的解释: 全局管理...

    Linux运维-运维课程d2-MySQL基本SQL语句(上)-03-客户端工具mysqladmin使用.mp4

    Linux运维-运维课程d2-MySQL基本SQL语句(上)-03-客户端工具mysqladmin使用.mp4

    MYSQL常用命令列表 .txt

    系统管理 ...mysqldump –u root –p --opt数据库名&gt;备份文件名 备份数据库(在mysql/bin) mysql –u root –p &lt; batch-file (例如备份文件名) 使用批处理 mysql.server start 启动服务器

Global site tag (gtag.js) - Google Analytics