To customize your mysql prompt, create a .my.cnf file in your $HOME then add the following:

[mysql]
prompt="\\u [\\d] >"

It will look like this:

username [dabatases_name] >