MySQL client tools and the use of MySQL client commands and Mysqladmin

MySQL Client Tools

used in MySQL The client tools have these:

MySQL: This is a command line client tool that is installed in the MySQL server, a command-line tool is automatically installed.

mysqldump: This is used to back up MySQL Client tools to use when using the

mysqladmin: This is a more commonly used MySQL client-side management tools, powerful features, will be introduced later

Mysqlcheck

Mysqlimport

MySQL command: MySQL client commands and server-side commands

login to using account and password mysql command to get all the mysql client command, of course, here's mysql command without a query and other sql command. where mysql Common client commands have these:

Note: MySQL A statement Terminator cannot be followed after a client command

\c: Early Termination SQL statement Execution (cannot precede user terminator)

\d: Define statement terminator, default to semicolon ";"

\s: Get status information for a server

      \. Sqltfile: execute SQL script file

\q: Exit MySQL Process

\h KEYWORD: get command Help

\g: regardless of the statement terminator, send this statement directly to the server-side Execution

\g: regardless of the statement Terminator, the statement is sent directly to the server-side execution, and the results are displayed in a vertical fashion

      \! Command: You can execute shell commands

\w: display a warning message when the statement ends

      \#: support for new objects with full complement functionality

server-side commands are our common query, delete, modify, insert, create, etc. SQL Statement

Note MySQL the server-side command must be followed by a statement terminator, and the default statement terminator is a semicolon ";" .

If you use a server-side command that you forgot, you can use the Help command to view.

Help KEYWORD you can get the use format for related keywords

For example: mysql> Help Select

Mysql the meaning of the cue symbol

mysql> represents the beginning of a new statement

→ indicates wait for input next line statement

' > represents waiting for another single quotation mark to end as the statement

"> represents waiting for another double quote to end as the statement

' > indicates waiting for another counter quote to end as the statement

/*> represents waiting for a statement to be entered in the comment specifier (*/) End as comment for the statement

Mysql Auto-complete function

1. Turn off the auto-completion feature of MySQL

using Commands -A {--no-auto-rehash|--disable-auto-rehash}

Example:mysql> use mysql-a--no-auto-rehash

Auto-complete function can be turned on or off relative to library or table

2. turn on auto-complete function

mysql> \# or mysql> Rehash

mysqladmin the Use

mysqladmin is a client-side tool for managing MySQL server, it is very powerful and is a very common and useful client management tool.

mysqladmin The syntax format is as follows:

mysqladmin [option] command [ARG] [command [ARG]] ...

Option

- u useranme: which user's account is used to manage

- P : password-related options

COMMAND:

Password ' new_password ': used to modify a user's password

For example: mysqladmin–u root–p password ' ABCD '

Create DATABASE: Create a library

Drop DATABASE : Deletes the specified library

Ping: can be used to check MySQL server-side is online

processlist:x Displays the active MySQL thread information, equivalent to executing SHOW processlist; Statement

Statues:These global state variables and their values are displayed, and these global state variables are:Uptime,Threads,Questions,Slow Queries,Opens,Flush Tables,Open Tables,Queries per second avg

where status has 2 sub-options:

--sleep NUM: show once every few seconds

--count: How many times does it show?

Extended-status: display server state variables and their values

variables: display server variables and their values

flush-privileges: Let mysqld reread authorization form, equivalent to Reload

Flush-status: Reset Most server state variables

Flush-logs: generate binary and trunk log scrolling

flush-hosts: refreshes the cache information on the host

Refresh: equivalent to simultaneous execution flush-hosts and the Flush-logs

Shutdown: Close MySQL Server Process

version: Displays the server version and its current status information

Start-slave: start replication and start the replication thread from the server.

Stop-slave: Turn off the replication feature

This article is from the "Linux Learning path" blog, so be sure to keep this source http://xslwahaha.blog.51cto.com/4738972/1576255

MySQL client tools and the use of MySQL client commands and Mysqladmin