path: root/posts/2008-08-08-customize-your-mysql-prompt.md



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] >`
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] >`