These show the user, hostname and database.
MYSQL_PS1="(\u@\h) [\d]> "
Rendering:
(jonasbn@[local]) [mydb]>