MySQL command-line arguments---These parameters are different from those parameters after mysqldump (there is a link at the beginning of the article): 2 types of parameters do not have the same meaning

Source: Internet
Author: User
Tags rehash sql error mysql command line ssl connection

mysql command-line arguments ---These parameters differ from those parameters after mysqldump : 2 Types of parameters have different meanings

One, MySQL command line parameters usage:mysql [OPTIONS] [Database]//Command mode-?,--Help//Display Help information and exit-I.,--HELP//Display Help information and exit--auto-rehash//Auto-complete function, like Linux inside, press the TAB key out of the same, there are examples-A,--no-auto-rehash//The default state is no auto-complete feature. -A is not auto-complete function-B,--batch//Ysql do not use history files, disable interaction(Enables--silent)--character-sets-dir=name//installation directory for font sets--default-character-Set=name//Set the default character set for a database-C,--compress//use compression when passing information on client and server side-#,--debug[=#]//Bug Call feature-D,--database=name//which database to use--delimiter=name//mysql default command terminator is a semicolon, below is an example- E,--execute=name//execute MySQL SQL statement-E,--vertical//Print query output vertically-F,--force//If there is an error jumping over, proceed to the following-G,--named-commands/*Enable named Commands. Named commands mean this program ' s internal commands; See mysql> Help. When enabled, the named commands can is used from any line of the "query, otherwise only from the first line, before an ENT Er. Disable with--disable-named-commands. This option was disabled by default.*/-G,--no-named-commands/*Named commands is 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//ignores spaces following the function name.--local-infile//Start/Disable the LOAD DATA LOCAL INFILE.-B,--no-beep//when a SQL error is disabled, the beep-H,--host=name// Set the server name or IP of the connection -H,--html//output in HTML mode-X,--xml//output in XML mode--line-numbers//Displays the line number of the error-L,--skip-line-numbers//ignore the wrong line number-N,--unbuffered//refreshes the cache after each SQL execution--column-names//display column information on search, plus by default-N,--skip-column-names// do not display column information -O,--Set-variable=name//Set Variable usage is--set-variable=var_name=var_value--sigint-ignore//Ignore SIGINT symbols (results of control-c when logging out)-O,--one-database//ignores statements except for the default database named in the command line. You can help skip updates to other databases in the log. --pager[=name]//Use the paging device to display the query output, which can be used in Linux more,less and so on. --no-pager//does not use a pager to display query output. -P,--password[=name]//input password-p,--port=#//Setting up Ports --prompt=name//set up a MySQL prompt--protocol=name//what protocol to use-Q,--quick//the results of the query are not cached, and each row is printed sequentially. If the output is suspended, the server slows down and MySQL does not use the history file. -R,--raw//writes the value of the column without escaping the transform. Typically used in conjunction with the--batch option. --reconnect//If the connection to the server is broken, automatically attempts to reconnect. No reconnection, use--disable-reconnect. -S,--silent//one-line output, tab-delimited in the middle-S,--socket=name//Sockey file that connects to the server--ssl//Activate SSL connection, do not activate--skip-ssl--ssl-ca=name//CA Certificate--ssl-capath=name//CA Path--ssl-cert=name//X509 Certificate--ssl-cipher=name//SSL cipher To use (implies--ssl).--ssl-key=name//X509 Key Name--ssl-verify-server-cert//Audit Server's certificate when connecting-T,--table//output as a tabular situation--tee=name//add an output copy to a given file, with--disable-tee when Forbidden--no-tee//The same as the root--disable-tee function-U,--user=name// user name -U,--safe-updates//Only allow to UPDATE and DELETE that uses keys.-U,--i-am-a-dummy//synonym for option--safe-updates,-U.-V,--verbose //output MySQL-executed statements-V,--version//Version Information-W,--wait//when the server is down, wait until the restart time--connect_timeout=#//Time to wait before connection--max_allowed_packet=#//server receive/Send packet maximum length--net_buffer_length=#//tcp/ The IP and socket communication buffer size. --select_limit=#//Automatic restriction of the SELECT statement when using--safe-updates--max_join_size=#//automatic restriction of rows in joins when using--safe-updates--secure-auth// Refuse to connect to the database using (pre-4.1.1)--server-arg=name//send Embedded Server this as a parameter. --show-warnings//Display warning

MySQL command-line arguments---These parameters are different from those parameters after mysqldump (there is a link at the beginning of the article): 2 types of parameters do not have the same meaning

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.