From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Date: Fri, 14 Sep 2007 13:56:26 +0400 From: Timur Batyrshin To: sysadmins@lists.altlinux.org Message-ID: <20070914135626.1217865f@batyrshin.ieml.ru> In-Reply-To: <20070914094345.GA16973@xeon.vladregion.ru> References: <20070914131203.11c1fca5@batyrshin.ieml.ru> <21bd5bb90709140217v1ef1a333sbc4abe8f05076cb@mail.gmail.com> <20070914094345.GA16973@xeon.vladregion.ru> Organization: IEML X-Mailer: Claws Mail 2.10.0cvs158 (GTK+ 2.10.6; i586-alt-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0255], KAS30/Release X-SpamTest-Info: Not protected X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.10/RELEASE, bases: 14092007 #392646, status: clean Subject: Re: [Sysadmins] mysql X-BeenThere: sysadmins@lists.altlinux.org X-Mailman-Version: 2.1.9 Precedence: list Reply-To: ALT Linux sysadmin discuss List-Id: ALT Linux sysadmin discuss List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 14 Sep 2007 09:56:32 -0000 Archived-At: List-Archive: Alexander Volkov (Fri, 14 Sep 2007 13:43:47 +0400): > MAP> 14.09.07, Timur Batyrshin =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB= (=D0=B0): > MAP> > =D0=90 =D0=BA=D0=B0=D0=BA =D1=83 =D0=BD=D0=B0=D1=81 =D0=B2=D0=BA= =D0=BB=D1=8E=D1=87=D0=B0=D0=B5=D1=82=D1=81=D1=8F =D1=81=D0=B5=D1=82=D1=8C = =D0=B2 mysql5 ? > MAP> > =D0=97=D0=B0=D0=BA=D0=BE=D0=BC=D0=BC=D0=B5=D0=BD=D1=82=D0=B8=D1=80= =D0=BE=D0=B2=D0=B0=D0=BB =D1=81=D1=82=D1=80=D0=BE=D1=87=D0=BA=D1=83 skip-ne= tworking > MAP> > =D0=B2 /var/lib/mysql/my.cnf, =D0=BF=D0=B5=D1=80=D0=B5=D0=B7=D0= =B0=D0=BF=D1=83=D1=81=D1=82=D0=B8=D0=BB =D1=81=D0=B5=D1=80=D0=B2=D0=B8=D1= =81. =D0=91=D0=BE=D0=BB=D1=8C=D1=88=D0=B5 =D0=BD=D0=B8=D1=87=D0=B5=D0=B3=D0= =BE > MAP> > =D0=B8=D0=B7 =D1=81=D1=82=D0=B0=D0=BD=D0=B4=D0=B0=D1=80=D1=82=D0= =BD=D0=BE=D0=B9 =D1=83=D1=81=D1=82=D0=B0=D0=BD=D0=BE=D0=B2=D0=BA=D0=B8 =D0= =BD=D0=B5 =D1=82=D1=80=D0=BE=D0=B3=D0=B0=D0=BB. > MAP> > > MAP> > =D0=92=D1=81=D0=B5 =D1=80=D0=B0=D0=B2=D0=BD=D0=BE =D0=B2=D1=8B=D0= =B4=D0=B0=D0=B5=D1=82=D1=81=D1=8F =D0=BE=D1=88=D0=B8=D0=B1=D0=BA=D0=B0: > MAP> > [root@mysql /]# mysqladmin -h 10.0.0.2 -u root password > MAP> > 'secretpassword' mysqladmin: connect to server at '10.0.0.2' > MAP> > failed error: 'Host '10.0.0.2' is not allowed to connect to > MAP> > this MySQL server' > MAP> > > MAP> > =D0=A7=D1=82=D0=BE-=D1=82=D0=BE =D0=B5=D1=89=D0=B5 =D0=BD=D1=83=D0= =B6=D0=BD=D0=BE =D1=81=D0=B4=D0=B5=D0=BB=D0=B0=D1=82=D1=8C? > =D0=B4=D0=BE=D0=B1=D0=B0=D0=B2=D0=B8=D1=82=D1=8C =D1=80=D0=B0=D0=B7=D1=80= =D0=B5=D1=88=D0=B5=D0=BD=D0=B8=D0=B5 =D1=80=D1=83=D1=82=D1=83 =D0=BF=D0=BE= =D0=B4=D0=BA=D0=BB=D1=8E=D1=87=D0=B0=D1=82=D1=8C=D1=81=D1=8F =D1=81 10.0.0.= 2? =D0=92=D0=BE=D1=82 =D0=B2 =D1=87=D0=B5=D0=BC =D0=B4=D0=B5=D0=BB=D0=BE. =D0= =A1=D0=BE=D0=B7=D0=B4=D0=B0=D0=BB =D0=BE=D1=82=D0=B4=D0=B5=D0=BB=D1=8C=D0= =BD=D0=BE=D0=B3=D0=BE =D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=D0=BE=D0=B2=D0=B0=D1= =82=D0=B5=D0=BB=D1=8F - =D0=B2=D1=81=D0=B5 =D0=B7=D0=B0=D1=80=D0=B0=D0=B1= =D0=BE=D1=82=D0=B0=D0=BB=D0=BE. =D0=A2=D0=BE=D0=B3=D0=B4=D0=B0 =D0=B4=D1=80=D1=83=D0=B3=D0=BE=D0=B9 =D0=B2= =D0=BE=D0=BF=D1=80=D0=BE=D1=81. =D0=A0=D0=B0=D0=B7 =D0=B4=D0=BE=D1=81=D1=82=D1=83=D0=BF =D1=80=D1=83=D1=82= =D1=83 =D1=81 =D0=B2=D0=BD=D0=B5=D1=88=D0=BD=D0=B8=D1=85 =D0=B8=D0=BD=D1=82= =D0=B5=D1=80=D1=84=D0=B5=D0=B9=D1=81=D0=BE=D0=B2 =D0=B7=D0=B0=D0=BF=D1=80= =D0=B5=D1=89=D0=B5=D0=BD, =D0=B7=D0=BD=D0=B0=D1=87=D0=B8=D1=82 =D0=BF=D0=B0= =D1=80=D0=BE=D0=BB=D1=8C =D0=BD=D0=B0 =D0=BD=D0=B5=D0=B3=D0=BE =D0=B4=D0=BE=D1=81=D1=82=D0=B0=D1=82=D0=BE=D1=87=D0=BD=D0=BE =D0=BD=D0=B0 = =D0=B4=D0=BE=D1=81=D1=82=D1=83=D0=BF =D1=81 =D0=BB=D0=BE=D0=BA=D0=B0=D0=BB= =D1=85=D0=BE=D1=81=D1=82=D0=B0 =D0=B2=D1=8B=D1=81=D1=82=D0=B0=D0=B2=D0=B8= =D1=82=D1=8C? =D0=98=D0=BB=D0=B8 =D0=BC=D0=BE=D0=B6=D0=BD=D0=BE =D0=BA=D0= =B0=D0=BA-=D0=BD=D0=B8=D0=B1=D1=83=D0=B4=D1=8C =D0=B7=D0=B0=D0=B4=D0=B0=D1=82=D1=8C =D0=B5=D0=BC=D1=83 =D0=BF=D0=B0=D1=80= =D0=BE=D0=BB=D1=8C (=D0=BD=D0=B0 =D0=B2=D1=81=D1=8F=D0=BA=D0=B8=D0=B9 =D1= =81=D0=BB=D1=83=D1=87=D0=B0=D0=B9) =D0=B8 =D0=BF=D1=80=D0=B8 =D0=B7=D0=B0= =D0=BF=D1=80=D0=B5=D1=89=D0=B5=D0=BD=D0=BD=D1=8B=D1=85 =D0=BF=D0=BE=D0=B4= =D0=BA=D0=BB=D1=8E=D1=87=D0=B5=D0=BD=D0=B8=D1=8F=D1=85 =D1=81=D0=BD=D0=B0=D1=80=D1=83=D0=B6=D0=B8?