Common options parameters under MySQL built-in directives

Source: Internet
Author: User
Tags mysql version mysql backup

In the process of using MySQL often for a variety of reasons, usually to MySQL backup, optimization and other operations to write scripts to facilitate management. If you want to write a script, then you have to use the option parameters of the built-in instructions for MySQL, here are a few more commonly used options parameters:

-h, --host=name         setting up a connected host-u, --user=name          Specify the user name to use-p, --password[=name]     enter the password-p, -- port=#           specifies the port to use-a,  --no-auto-rehash        do not use auto-completion to achieve a faster MySQL run-b,  --batch                 do not use history files. Disables interactive behavior. -s,  --silent               The output of a row of rows, with the print result of a tab character as a delimiter-s,  --socket=name          Connect to the database using the socket file-e,  --execute=name         Do not enter MySQL interactive interface to execute SQL statements, this often use-e,  --vertical              print the output in a row, equivalent to using SQLNAME\G-#,  --DEBUG[=#]&N in the MySQL interactive interfaceBsp;          debug Debug, used to find the bug with-v,  --version               query MySQL version information

Of course, MySQL's built-in command parameter options are many, here is not introduced, if you want to learn more, you can through the MySQL--help

Option parameters Find out more about MySQL official help

This article from the "Technical essay" blog, reproduced please contact the author!

Common options parameters under MySQL built-in directives

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: info-contact@alibabacloud.com 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.