博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
个性化设置 MySQL prompt 提示符
阅读量:5820 次
发布时间:2019-06-18

本文共 2425 字,大约阅读时间需要 8 分钟。

hot3.png

个性化设置 MySQL prompt 提示符

下面谈 4 种方法

1. 在 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]>

2. 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)]>

3. 配置文件 /etc/my.cnf

[mysql]prompt=(\\u@\\h) [\\d]>\\_

又或者:

[mysql]prompt="\\r:\\m:\\s> "

要多加一个反斜线\.

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

转载于:https://my.oschina.net/u/930279/blog/807458

你可能感兴趣的文章
监听器(web基础学习笔记二十二)
查看>>
802.11 学习笔记
查看>>
Leetcode-Database-176-Second Highest Salary-Easy(转)
查看>>
构建Docker Compose服务堆栈
查看>>
最小角回归 LARS算法包的用法以及模型参数的选择(R语言 )
查看>>
CentOS7下zip解压和unzip压缩文件
查看>>
Hadoop生态圈-Kafka常用命令总结
查看>>
如何基于Redis Replication设计并实现Redis-replicator?
查看>>
Linux 环境下 PHP 扩展的编译与安装 以 mysqli 为例
查看>>
浮点数内存如何存储的
查看>>
贪吃蛇
查看>>
EventSystem
查看>>
用WINSOCK API实现同步非阻塞方式的网络通讯
查看>>
玩一玩博客,嘿嘿
查看>>
P1352 没有上司的舞会
查看>>
ios11文件夹
查看>>
【HLOJ 559】好朋友的题
查看>>
Electric Fence(皮克定理)
查看>>
nvl 在mysql中如何处理
查看>>
MyEclipse 快捷键
查看>>