Common options parameters under MySQL built-in directives

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