Regular Expressions 101

Character Class[\s]*

*matches any number of characters from the set below:

\sany whitespace character

Negated Character Class[^;]

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

Character Class[\s]*

*matches any number of characters from the set below:

\sany whitespace character

server-idthe literal text server-id (case insensitive)

Character Class[\s]*

*matches any number of characters from the set below:

\sany whitespace character

=the literal = (61₁₀ / 75₈ / 3D₁₆)

Character Class[\s]*

*matches any number of characters from the set below:

\sany whitespace character

Group 1(.\d)

.any character (except for line terminators)

\da digit

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

[\s]*[^;][\s]*server-id[\s]*=[\s]*(.\d)

New

#       other settings you may need to change.
  ;  server-id        =   1
log_bin                 = /var/log/mysql/mysql-bin.log