mysql — The MySQL Command-Line Client Option Description \C The current connection identifier \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 \m Minutes of the current time 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 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 You can set the prompt in several ways: • Use an environment variable.  You can set the  MYSQL_PS1  environment variable to a prompt string. For example: • Use a command-line option.  You can set the  --prompt  option on the command line to  mysql . For example: export MYSQL_PS1="(\u@\h) [\d]> " 439