Re: MySQL

On Sun, 06 Feb 2005 03:12:10 +0200
Ignatiy Goloviznin <[email protected]> wrote:

> Roman Shiryaev =D0=C9=DB=C5=D4:
> > $ urpmf my.*cnf
> > MySQL-common:/usr/share/mysql/my-huge.cnf
> > MySQL-common:/usr/share/mysql/my-large.cnf
> > MySQL-common:/usr/share/mysql/my-medium.cnf
> > MySQL-common:/usr/share/mysql/my-small.cnf
>=20
> =E1 =CB=C1=CB=CF=CA =C9=DA =CE=C9=C8 =CB=CF=D0=C9=D2=CF=D7=C1=D4=D8 =D3 =
=C9=CD=C5=CE=C5=CD my.cnf =D7 etc?
=D4=CF=D4 =CB=CF=D4=CF=D2=D9=CA =F7=C1=CD =CE=D5=D6=C5=CE.
=D3=D5=C4=D1 =D0=CF =CE=C1=DA=D7=C1=CE=C9=D1=CD =C9 =D3=CF=C4=C5=D2=D6=C9=
=CD=CF=CD=D5 =CE=C1=DE=C1=CC=C1 =DC=D4=C9=C8 =C6=C1=CA=CC=CF=D7 - =D7=D9=C2=
=C9=D2=C1=C5=D4=C5 =C4=CC=D1 =D3=D7=CF=C5=CA =D3=C9=D3=D4=C5=CD=D9.

>=20
> [root@localhost ignat]# mysql_setpermission --user root --password=20
> --host root@localhost
> Can't make a connection to the mysql server.
>   The error: Access denied for user: 'root@localhost' (Using password:=20
> YES) at /usr/bin/mysql_setpermission line 70.
=CD=CF=D6=C5=D4 mysql =CE=C5 =DA=C1=D0=D5=DD=C5=CE? =C9=CC=C9 =D0=CF=D0=D2=
=CF=C2=D5=CA=D4=C5 =C2=C5=DA --host

> > =D5=DE=C9 SQL -- =C9=CE=C1=DE=C5 =CE=C9=CB=C1=CB. =E9=CC=C9 =D4=C5=C2=
=C5 =C7=CF=D4=CF=D7=D9=C5 =DA=C1=D0=D2=CF=D3=D9 =CE=D5=D6=CE=D9?
>=20
> =F5=DE=C9=D4=D8 =C7=C4=C5? =F0=D2=C9 =D3=CF=DA=C4=C1=CE=C9=C9 =C2=C1=DA=
=D9 =D7=D9=C4=C1=A3=D4=D3=D1 =CF=DB=C9=C2=CB=C1:
=C4=CF=CB=D5=CD=C5=CE=D4=C1=C3=C9=C9, =C9=C4=D5=DD=C5=CA =D3 =D3=C5=D2=D7=
=C5=D2=CF=CD - =D7=D0=CF=CC=CE=C5 =C4=CF=D3=D4=C1=D4=CF=DE=CE=CF =C4=CC=D1 =
=D3=CF=DA=C4=C1=CE=C9=D1 =D3=C5=D2=D8=C5=DA=CE=D9=C8 =D0=D2=C9=CC=CF=D6=C5=
=CE=C9=CA.

>=20
> =EB=C1=CB =D3=CF=DA=C4=C1=D4=D8 =D0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=D1 =C9 =
=D0=D2=CF=D0=C9=D3=C1=D4=D8 =C5=CD=D5 =D0=C1=D2=CF=CC=D8 =D1 =CE=C5 =CE=C1=
=DB=A3=CC, =CB=C1=CB=20
connect mysql;
select * from user;
update user set password=3D"some_password" where user=3D"some_user"
insert into user values(.......);

> =F0=CF=DE=C5=CD=D5 connect =CE=C1 'localhost' =CE=C5 =D0=D2=CF=C8=CF=C4=
=C9=D4? =E8=CF=D4=D1
>=20
> [ignat@localhost ignat]$ mysqlshow
> +-----------+
> | Databases |
> +-----------+
> +-----------+
=C5=C4=C9=CE=D3=D4=D7=C5=CE=CE=C1=D1 =C2=C1=DA=C1, =C4=CF=D3=D4=D5=D0=CE=C1=
=D1 =C4=CC=D1 =D7=D3=C5=C8 =D0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=C5=CA  - test,=
 =D4=D9 =C5=C5 =D5=D6=C5 =D5=C4=C1=CC=C9=CC.
>=20
> [root@localhost ignat]# mysqlshow
> mysqlshow: Access denied for user: 'root@localhost' (Using password: NO)
> [root@localhost ignat]#

=D3=C1=CD=CF =D3=CF=C2=CF=CA - =D0=D2=C1=D7 =CE=C5=D4.

=E5=DD=C5 =D2=C1=DA - =D0=D2=CF=DD=C5 =D0=CF=D3=D4=C1=D7=C9=D4=D8 gui =C4=
=CC=D1 =CE=C1=DE=C1=CC=D8=CE=CF=C7=CF =C9=DA=D5=DE=C5=CE=C9=D1.

--=20
WINS1-UANIC