mysql提示符的修改过程

本篇内容介绍了"mysql提示符的修改过程"的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

㈠ 在 Bash 层修改 MYSQL_PS1 变量

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]>

㈡ MySQL 命令行参数

[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)]>

㈢ 配置文件 /etc/my.cnf

[mysql]prompt=(\\u@\\h) [\\d]>\\_ 又或者：[mysql]prompt="\\r:\\m:\\s> "要多加一个反斜线\.

㈣ 在 MySQL 中使用 prompt 命令

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

附录：

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

"mysql提示符的修改过程"的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注网站，小编将为大家输出更多高质量的实用文章！