Skip to content

Getting a better MySQL prompt

When you want to see which user you are and which database you’re working with, put this in .my.cnf:

prompt=(\\u@\\h) [\\d]>\\_

Too bad mysql doesn’t support color. You can make it work with rlwrap, but that’s kind of clumsy.

edit: hmm, this destroys mysqldump… argh.


    4 Comments ( Add comment / trackback )

    1. (permalink) Trackback from Quanweiai.com
      On Feb 27, 2016 at 22:04

      Quanweiai.com

      BigSmoke » Getting a better MySQL prompt

    2. On Mar 26, 2016 at 15:32

      click to find out more

      BigSmoke » Getting a better MySQL prompt

    3. On Apr 29, 2016 at 07:42

      ackermans store card online application

      BigSmoke » Getting a better MySQL prompt

    4. On Apr 30, 2016 at 08:55

      cheap furniture stores in south jersey

      BigSmoke » Getting a better MySQL prompt

    Post a comment

    (required)
    (required)

    Your email is never published nor shared.

    (optional)
    Allowed HTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>