method 1) $ export MYSQL_PS1="\u@\h [\d]> " method 2) mysql> prompt \u@\h [\d]> method 3) $ mysql --prompt="\u@\h [\d]> " -u root -pyour-password method 4) $ vi ~/.my.cnf [mysql] prompt=\\u@\\h [\\d]>\\_