Skip to content

Instantly share code, notes, and snippets.

@matiskay

matiskay/README.md

Created January 11, 2012 20:24
Show Gist options
  • Save matiskay/1596583 to your computer and use it in GitHub Desktop.
Save matiskay/1596583 to your computer and use it in GitHub Desktop.
Download ZIP
Change mysql prompt
Raw
README.md

Change your mysql prompt

Use an environment variable. You can set the MYSQL_PS1 environment variable to a prompt string. For example:

  export MYSQL_PS1="(\u@\h) [\d]> "

More info

  • man mysql
Raw
mysql-prompt.sql
PROMPT set to '(\u@\h) [\d]>\_'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment