MySQL Learning Note (2)-Two ways to modify the MySQL prompt

Study in http://www.imooc.com/video/1806 Network

1. Method One: cmd in the not logged in state, enter

Mysql-uroot-p own password--prompt new prompt

Example: mysql-uroot-p111111--prompt \h

111111 for your own password, \h refers to localhost

2. Method Two: When the cmd is in the login state, enter

Prompt new Prompt

Example:

3. The parameters that the prompt can use:

1) \d: Full Date

2) \d: Current Database

3) \h: Current host name

4) \u: Current User

Example: Entering

Prompt \[email protected]\h \d

None indicates that no database is open.

MySQL Learning Note (2)-Two ways to modify the MySQL prompt