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

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

Your prompt will now looks like this: `username [dabatases_name] >`