Sunday, April 17, 2005

Chang the Mysql client prompt

Changing the Mysql client prompt: (Mysql 4.0.2 and higher)


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

Put in my.cnf


1 comment:

Anonymous said...

this setting should actually come under the [client] section in the cnf file. i.e.

prompt = \u@\h|\d

which gives