How to pretty-print my.cnf with a one-liner

When I’m looking at a server, I often want to see the /etc/my.cnf file nicely formatted, and with comments stripped. This Perl one-liner will pretty-print the file:

Share this post

Comments (17)

  • Marc Handelman

    Very nice, thanks!

    June 15, 2009 at 7:51 am
  • deminy

    Thanks for sharing.

    June 15, 2009 at 8:05 am
  • Jeff Schroeder

    Besides forcing the spacing with the printf, this looks the same as: egrep -v ‘^$|^#’ /etc/my.cnf

    June 15, 2009 at 9:38 am
  • julien antony

    Nice, i like awk so i give you mine with sections separated by a line:
    awk ‘! /^#/ && ! /^$/ {if($1 ~ /^\[/ ){gsub(“\[“,”\n[“,$1) };printf(“%-35s%s %s\n”,$1, $2, $3)}’ /etc/my.cnf


    June 15, 2009 at 12:50 pm
  • Jacob Sohn

    shorter version – 🙂
    awk ‘! /(^#|^$)/ {printf “%-34s %s %s\n”, $1, $2, $3}’ /etc/my.cnf

    if you don’t care about pretty formats – 🙂
    grep -Ev ‘(^#|^$)’ /etc/my.cnf


    June 15, 2009 at 5:30 pm
  • Baron Schwartz

    The awk versions work well as long as there’s whitespace, but they won’t pretty-print


    I like awk too, but I’m so clumsy with it that I’m not sure what to do to fix that!

    (PS: the Perl version doesn’t pretty-print things without whitespace perfectly either, but it’s pretty enough for me)

    June 15, 2009 at 6:37 pm
  • Jacob Sohn

    using field separator option and if condition, with or without white space shows pretty format – 🙂

    awk -F= ‘! /(^#|^$)/ { if ($2 != “”) printf “%-34s = %s\n”, $1,$2; else printf “%s\n”, $1 }’ /etc/my.cnf

    I admit, this is longer than i want it to be…


    June 15, 2009 at 10:55 pm
  • julien antony

    for pretty output with colors, you can use this python script: also useful for logs.

    June 16, 2009 at 12:13 am
  • Seth

    Any hints on how to get this to work as a bash alias?

    I would like to add something like this to my .bashrc:

    alias printmycnf=

    but no amount of quote hacking is getting it to work.

    Or has someone refactored it has a perl script? I think I could do that, but my first attempt was taking longer than 5 minutes so I thought I would ask.


    June 17, 2009 at 10:11 am
  • Seth

    Should have said:

    alias printmycnf=[insert perl one-liner]

    June 17, 2009 at 10:12 am
  • Jacob Sohn

    knowning where to escape, you should be able to do as this;

    alias printmycnf=’awk -F= “! /(^#|^$)/ { if (\$2 != \”\”) printf \”%-34s = %s\n\”, \$1,\$2; else printf \”%s\n\”, \$1 }”‘

    you can replace with perl one-liner where awk is.


    June 17, 2009 at 8:13 pm
  • Seth

    @Jacob – Not sure what’s going on here… but the quoting is messed up. Appears to be the MS-SmartQuotes / unicode issue. Some of the double-quotes above are leaning one direction and some are leaning the other way. When I paste it as is into my terminal I get:

    alias printmycnf=.awk -F= .! /(^#|^$)/ { if (\$2 != \.\.) printf \.%-34s = %s\n\., \$1,\$2; else printf \.%s\n\., \$1 }..

    Did you copy and paste from somewhere weird, like a word document or something? I tried to modify it back to what it should be:

    alias printmycnf=’awk -F= “! /(^#|^$)/ { if (\$2 != \”\”) printf \”%-34s = %s\n\”, \$1,\$2; else printf \”%s\n\”, \$1 }”‘

    But when I ran it (RHEL 4.8) it just hung. I’ve tried inserting the perl string as an alias and doing various things to escape the quotes w/l much luck.

    I guess I could just put the command into a shell script for now.

    June 17, 2009 at 8:27 pm
  • Seth

    Appears that WordPress is messing up the quotes for us, as my post is exhibiting the same quoting issue.

    June 17, 2009 at 8:28 pm
  • Jacob Sohn


    Yeah, the “,’,` characters gets altered from ISO-8859-1 to UTF-8 probably. Copy and paste the code and just replace those characters with proper ones. Then all should work fine.


    June 17, 2009 at 9:43 pm
  • Seth

    I tried that, but it just hung.

    June 18, 2009 at 12:30 am
  • Jacob Sohn


    have you tried “printmycnf /etc/my.cnf” after alias command?

    On my system;
    $ alias printmycnf=’awk -F= “! /(^#|^$)/ { if (\$2 != \”\”) printf \”%-34s = %s\n\”, \$1,\$2; else printf \”%s\n\”, \$1 }”‘
    $ printmycnf /etc/my.cnf

    works like a charm.

    ps: don’t forget to replace single quote and double quote. better yet, just type it in manually.

    June 23, 2009 at 4:39 pm
  • Seth

    Thanks, I got it working now. I don’t think I was including the filename before.

    June 23, 2009 at 5:53 pm

Comments are closed.

Use Percona's Technical Forum to ask any follow-up questions on this blog topic.