MySQLCustomize PS1

Customize the MySQL PS1 with current database

In the .bashrc or .bash_profile, adding:

export MYSQL_PS1="\[email protected]\h [\d]>"

make the MySQL client PROMPT show current [email protected] [database].

enter image description here

Custom PS1 via MySQL configuration file

In mysqld.cnf or equivalent:

[mysql]
prompt = '\[email protected]\h [\d]> '

This achieves a similar effect, without having to deal with .bashrc's.