mysql -uroot -p --prompt="//u@//h://d //r://m://s>"
设置成功后：
复制代码 代码如下:
Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 5 Server version: 5.1.60-log Source distribution Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '/h' for help. Type '/c' to clear the current input statement. root@localhost:(none) 11:04:23>
也可以在在my.cnf配置文件里进行配置：
复制代码 代码如下:
[mysql] prompt=mysql(//u@//h://d)>
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.Vevb.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
