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