Customize MySQL prompt

Four interview methods

(I) modify the variable mysql_ps1 at the bash layer.

[root@localhost ~]# export MYSQL_PS1="(\u@\h) [\d]> "[root@localhost ~]# mysql -u root -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 73Server version: 5.5.28 MySQL Community Server (GPL)Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.(root@localhost) [(none)]> use test;Database changed(root@localhost) [test]> 

(Ii) MySQL command line parameters

[root@localhost ~]# mysql -u root -p --prompt="(\u@\h) [\d]> "Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 74Server version: 5.5.28 MySQL Community Server (GPL)Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.(root@localhost) [(none)]> 

(3) configuration file/etc/My. CNF

[MySQL] prompt = (\ U @ \ h) [\ D]> \ _ or: [MySQL] prompt = "\ r: \ m: \ s> "add a backslash \.

(Iv) Use the prompt command in MySQL

mysql> prompt \r:\m:\s\P>\_PROMPT set to '\r:\m:\s\P>\_'08:20:42pm> promptReturning to default PROMPT of mysql> mysql> 

Appendix:

OptionDescription\cA counter that increments for each statement you issue\DThe full current date\dThe default database\hThe server host\lThe current delimiter (new in 5.0.25)\mMinutes of the current time\nA newline character\OThe current month in three-letter format (Jan, Feb, …)\oThe current month in numeric format\Pam/pm\pThe current TCP/IP port or socket file\RThe current time, in 24-hour military time (0–23)\rThe current time, standard 12-hour time (1–12)\SSemicolon\sSeconds of the current time\tA tab character\UYour full user_name@host_name account name \uYour user name\vThe server version\wThe current day of the week in three-letter format (Mon, Tue, …)\YThe current year, four digits\yThe current year, two digits\_A space\ A space (a space follows the backslash)\'Single quote\"Double quote\\A literal “\” backslash character\xx, for any “x” not listed above