MySQL command line login _ MySQL

Environment introduction OS: CentOS6XWin2008MySQL version: 55x in addition to common MySQL management tools, MySQL client command line tools are often used to install the command line tool in 1 Linux (1) enable epel Source: (2) introduction to installing MySQL command line tool y environment
OS: CentOS6.X & Win2003 & Win2008
MySQL version: 5.5.x

In addition to common MySQL management tools, MySQL client command line tools are often used.
1. install the command line tool in Linux
(1) enable epel Source:
(2) install the MySQL command line tool
# Yum-y install mysql
2. common command lines:
# Mysql -- help


3. instance syntax:
Mysql-u root-pxxxxx-h 127.0.0.1-P 23306
Mysql-u User name [-h host name or IP address]-p password
Note: the user name is the user you log on to. the host name or IP address is optional. the local connection is not allowed, and the IP address and port must be used for remote connection.
Note:
1. lowercase-p is passwd, and uppercase-P is Port
2. the host name or IP address is optional. the local connection cannot be written, and the IP address and port must be written for the remote connection.