Mysql修改默认提示符

mysql修改默认提示符

临时修改

mysql> prompt [\u@db1 \r:\m:\s]-->
PROMPT set to '[\u@db1 \r:\m:\s]-->'
[root@db1 04:59:34]-->
[root@db1 04:59:36]-->
[root@db1 04:59:36]-->

永久生效

加放/etc/my.cnf [mysql]模块中，注意不是mysqld

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysql]
prompt=[\\u@db1 \\r:\\m:\\s]-->