MySQL Client tool parameters in a detailed

Client Tools: Mysql,mysqladmin,mysqldump,mysqlcheck

Administrative tools for non-client classes: Myisamchk,myisampack

MySQL command prompt

mysql> Wait for input command

' No end provided ' in front of > '

">

' >

--Endurance character

/*> Comment Information

MySQL command-line edit shortcut keys

Ctrl+w: Delete A word before the cursor is located

Ctrl+u: Delete all content before the cursor to the beginning of the line

Ctrl+y: Paste the contents of ctrl+w or ctrl+u deleted before

CTRL + A: Move the cursor to the beginning

Ctrl+e: Move cursor to end of line

MySQL command-line options

-u,--user=

-H,--host=

-P,--password=

--protocol={tcp|socket|memory|pipe}

--port=

--socket=/tmp/mysql.sock

--compress Compression Transmission

--default-character-set Character Set

-V: Show version number

-V: Show more information

--SSL-CA CA Certificate

--ssl-capath The CA Certificate folder

--ssl-cert Client Certificate

--ssl-cipher Encrypted tears

Private key used by--ssl-key

--ssl-verify-server-cert Verifying server-side certificates

--database=-D: Specify the database to use

-H--html: Document with output as HTML format

-X--xml: Document with output as XML format

--safe-updates: Deny use of uodate or delete commands without a WHERE clause when sending commands

Mysqladmin Tools

mysqladmin [Options] command [ARG] [Command[arg]] .....

Here are the command options supported by the Commands section

Create db_name creating an empty database

-E: Return directly

Drop db_name Delete Database

Debug Open debug Log and log in with error log

Status: Output Summary status information

-sleep # Specifying display delay

-count # Specifying Batches

Extended-status: Each state variable and value of the output MYSQ is equivalent to executing "mysql> show global Status"

Flush-hosts: Empty host-related cache: DNS resolution cache, previously denied access to mysqld host list due to excessive number of connection errors

Flush-logs: Log scrolling, primarily binary logs and trunk logs

Refresh: Equivalent to simultaneous use of flush-logs and flush-hosts

Flush-privileges: Notifies the server to reread the authorization form

Reload: Overloaded Authorization table

Flush-status: Resetting the value of a state variable

Flush-tables: Closes the currently open table file handle

Flush-threads: Emptying the thread cache

Kill: Kills the specified thread and can kill multiple threads at once, separated by commas, but not with extra spaces

Password: Modify the password for the specified user

Processlist: List of threads

Shutdown: Close the mysqld process

Start-slave Boot from server process

Stop-slave shutdown from server process

Variables: Displays the MySQL server processes

MySQL Client tool parameters in a detailed