在預設的情況下,在 command line 連接 MySQL 資料庫時,會使用以下的提示符號:

mysql>

如果將以上提示符號變更,可以顯示更多資訊的話,操作起來會相當方便。要變更這個提示符號首先開啟 my.cnf 檔案(Windows 用戶是 my.ini),然後在 [mysql] 區間加入以下語句:

prompt=u@h:[d]>_

上面語句的 "u" 及 "h" 分別會顯示用戶名稱及主機名稱,"d" 會顯示所選擇的資料庫,以下是上面設定的提示符號:

samtang@localhost:[hkcode]>

以下是 MySQL 提示符號可用的參數:

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.0.25)
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   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