Message from discussion
User privileges replication
Received: by 10.52.240.229 with SMTP id wd5mr21895351vdc.8.1338294310620;
Tue, 29 May 2012 05:25:10 -0700 (PDT)
X-BeenThere: codership-team@googlegroups.com
Received: by 10.220.140.139 with SMTP id i11ls2825705vcu.1.gmail; Tue, 29 May
2012 05:25:10 -0700 (PDT)
Received: by 10.52.23.226 with SMTP id p2mr493442vdf.2.1338294310181;
Tue, 29 May 2012 05:25:10 -0700 (PDT)
Date: Tue, 29 May 2012 05:25:09 -0700 (PDT)
From: Laurent MINOST <lolo...@gmail.com>
To: codership-team@googlegroups.com
Message-Id: <62b86c9f-c85c-4f6e-b1d7-550f78e29e37@googlegroups.com>
Subject: User privileges replication
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_Part_223_20058710.1338294309683"
------=_Part_223_20058710.1338294309683
Content-Type: multipart/alternative;
boundary="----=_Part_224_5368963.1338294309683"
------=_Part_224_5368963.1338294309683
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Hi,
Is this normal that this query is not propagated/replicated over the whole
cluster please :
SET PASSWORD FOR 'root'@'localhost' = PASSWORD( '********' )
This change the local node password on which I'm currently connected but
does not update the password on the others connected node ?
Thanks.
Regards,
Laurent
------=_Part_224_5368963.1338294309683
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Hi,<div><br></div><div>Is this normal that this query is not propagated/rep=
licated over the whole cluster please : </div><div><br><span class=3D"=
syntax_alpha syntax_alpha_reservedWord" style=3D"color: rgb(153, 0, 153); t=
ext-transform: uppercase; font-weight: bold; font-family: sans-serif; font-=
size: 10px; text-align: -webkit-left; background-color: rgb(229, 229, 229);=
">SET</span><span style=3D"color: rgb(0, 0, 0); font-family: sans-serif; f=
ont-size: 10px; text-align: -webkit-left; background-color: rgb(229, 229, 2=
29); "> </span><span class=3D"syntax_alpha syntax_alpha_reservedWord" =
style=3D"color: rgb(153, 0, 153); text-transform: uppercase; font-weight: b=
old; font-family: sans-serif; font-size: 10px; text-align: -webkit-left; ba=
ckground-color: rgb(229, 229, 229); ">PASSWORD</span><span style=3D"color: =
rgb(0, 0, 0); font-family: sans-serif; font-size: 10px; text-align: -webkit=
-left; background-color: rgb(229, 229, 229); "> </span><span class=3D"=
syntax_alpha syntax_alpha_reservedWord" style=3D"color: rgb(153, 0, 153); t=
ext-transform: uppercase; font-weight: bold; font-family: sans-serif; font-=
size: 10px; text-align: -webkit-left; background-color: rgb(229, 229, 229);=
">FOR</span><span style=3D"color: rgb(0, 0, 0); font-family: sans-serif; f=
ont-size: 10px; text-align: -webkit-left; background-color: rgb(229, 229, 2=
29); "> </span><span class=3D"syntax_quote syntax_quote_single" style=
=3D"color: rgb(0, 128, 0); white-space: pre; font-family: sans-serif; font-=
size: 10px; text-align: -webkit-left; background-color: rgb(229, 229, 229);=
">'root'</span><span class=3D"syntax_punct syntax_punct_user" style=3D"col=
or: fuchsia; font-family: sans-serif; font-size: 10px; text-align: -webkit-=
left; background-color: rgb(229, 229, 229); ">@</span><span class=3D"syntax=
_quote syntax_quote_single" style=3D"color: rgb(0, 128, 0); white-space: pr=
e; font-family: sans-serif; font-size: 10px; text-align: -webkit-left; back=
ground-color: rgb(229, 229, 229); ">'localhost'</span><span style=3D"color:=
rgb(0, 0, 0); font-family: sans-serif; font-size: 10px; text-align: -webki=
t-left; background-color: rgb(229, 229, 229); "> </span><span class=3D=
"syntax_punct" style=3D"color: fuchsia; font-family: sans-serif; font-size:=
10px; text-align: -webkit-left; background-color: rgb(229, 229, 229); ">=
=3D</span><span style=3D"color: rgb(0, 0, 0); font-family: sans-serif; font=
-size: 10px; text-align: -webkit-left; background-color: rgb(229, 229, 229)=
; "> </span><span class=3D"syntax_alpha syntax_alpha_functionName" sty=
le=3D"color: rgb(255, 0, 0); text-transform: uppercase; font-family: sans-s=
erif; font-size: 10px; text-align: -webkit-left; background-color: rgb(229,=
229, 229); ">PASSWORD</span><span class=3D"syntax_punct syntax_punct_brack=
et_open_round" style=3D"color: fuchsia; font-family: sans-serif; font-size:=
10px; text-align: -webkit-left; background-color: rgb(229, 229, 229); ">(<=
/span><span style=3D"color: rgb(0, 0, 0); font-family: sans-serif; font-siz=
e: 10px; text-align: -webkit-left; background-color: rgb(229, 229, 229); ">=
</span><span class=3D"syntax_quote syntax_quote_single" style=3D"colo=
r: rgb(0, 128, 0); white-space: pre; font-family: sans-serif; font-size: 10=
px; text-align: -webkit-left; background-color: rgb(229, 229, 229); ">'****=
****'</span><span style=3D"color: rgb(0, 0, 0); font-family: sans-serif; fo=
nt-size: 10px; text-align: -webkit-left; background-color: rgb(229, 229, 22=
9); "> </span><span class=3D"syntax_punct syntax_punct_bracket_close_r=
ound" style=3D"color: fuchsia; font-family: sans-serif; font-size: 10px; te=
xt-align: -webkit-left; background-color: rgb(229, 229, 229); ">)</span>&nb=
sp;<br></div><div><br></div><div>This change the local node password on whi=
ch I'm currently connected but does not update the password on the others c=
onnected node ?<br><br>Thanks.<br>Regards,<br><br>Laurent</div>
------=_Part_224_5368963.1338294309683--
------=_Part_223_20058710.1338294309683--