database

How do I change the MySQL client prompt?

How do I change the MySQL client prompt? (MySQL 4.0.2 and higher)

(from http://dev.mysql.com/doc/mysql/en/mysql_Commands.html)

e.g. “prompt \d\R\m>” will show the current database + millitary hour + minutes

Put it in my.cnf

[mysql]
prompt=”\\d\\R\\m>”

2 Comments

2 Comments

  1. free hosting template

    July 2, 2010 at 1:18 am

    Everything has been shared with great details. Thanks for posting this entry.

  2. turnkeylinux

    August 27, 2010 at 11:39 pm

    good post!

Leave a Reply

Your email address will not be published. Required fields are marked *

To Top