mysql -prompt选项

最新推荐文章于 2021-02-07 11:39:11 发布

weixin_33979745

最新推荐文章于 2021-02-07 11:39:11 发布

阅读量142

点赞数

文章标签：数据库网络

本文介绍了如何通过四种方式修改MySQL命令行的提示符：使用命令行参数、编辑配置文件、在MySQL内部使用prompt命令以及设置Bash环境变量。此外还提供了可用于提示符中的各种特殊符号及其含义。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用-pormpt修改提示符。可以在登录时或者在登录后使用prompt选项来修改提示符

(1)使用mysql命令行参数修改提示符

# mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 27
Server version: 5.6.25 Source distribution

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

# mysql -uroot -p --prompt="\\u@\\h:\\d \\r:\\m:\\s>"  
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 28
Server version: 5.6.25 Source distribution

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

#切换数据库
root@localhost:(none) 10:05:25>use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
root@localhost:test 10:05:31>

(2)修改配置文件/etc/my.cnf

[mysql]
prompt="\\u@\\h:\\d \\r:\\m:\\s>"

(3)在 MySQL 中使用 prompt 命令

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

(4)当然可以在在Bash层修改 MYSQL_PS1变量

# export MYSQL_PS1="(\u@\h) [\d]> "
# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.6.25 Source distribution

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

(root@localhost) [(none)]> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
(root@localhost) [test]>

参数辅助说明

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.1.12)
`\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