mysql提示符prompt的用法

随着管理mysql服务器越来越多，同样的mysql>的提示符有可能会让你输入错误的命令到错误的数据库，这时候需要巧用mysql的提示符，这 是我的提示符root@localhost(mysql) 08:55:21> 用prompt命令实现(适用于windows和linux环境)

mysql>prompt \u@\h(\d) \r:\m:\s>
\u:连接用户
\h:连接主机
\d:连接数据库
\r:\m:\s:显示当前时间
mysql>prompt \u@\h(\d) \r:\m:\s>
root@localhost(mysql) 08:55:21> status

设置方式=>

<1>mysql -uroot -p --prompt="(\\u@\\h)[\\d] \\r:\\m:\\s>"

<2>mysql> prompt (\u@\h)[\d]\r:\m:\s>

<3>也可以在在my.cnf配置文件里进行配置：

[mysql]/[client]

prompt="(\\u@\\h)[\\d] \\r:\\m:\\s>"

default-character-set=utf8 

附:

Option  Description  
\c  A counter that increments for each statement you issue  
\D  The full current date  
\d The default database  
\h The server host  
\l The current delimiter (new in 5.1.12)  
\m  Minutes of the current time  
\n  A newline character  
\O  The current month in three-letter format (Jan, Feb, …)  
\o  The current month in numeric format  
\P  am/pm  
\p The current TCP/IP port or socket file  
\R  The current time, in 24-hour military time (0–23)  
\r  The current time, standard 12-hour time (1–12)  
\S  Semicolon  
\s  Seconds of the current time  
\t  A tab character  
\U   www.2cto.com    
Your full user_name@host_name account name  
   
\u Your user name  
\v  The server version  
\w  The current day of the week in three-letter format (Mon, Tue, …)  
\Y  The current year, four digits  
\y  The current year, two digits  
\_  A space  
\   A space (a space follows the backslash)  
\'  Single quote  
\"  Double quote  
\\  A literal “\” backslash character  
\x   
x, for any “x” not listed above