Customizing the MySQL Prompt

mysql

MySQL Prompt is default.

mysql>

I like this customizing that is [user name]@[host][selected database name], as follows.

root@localhost[hoge]>

Change the mysql> prompt using my.cnf or configration file for shell.

for example .zshrc, as follows.

export MYSQL_PS1='\U[\d]> '

for example my.cnf, as follows.

[mysql]
prompt='\\U[\\d]> '

you can customize the MySQL Prompt if you want. http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html