Re: MySQL

"Andrey N. Kobluk" <[email protected]> Tue, 8 Feb 2005 09:08:28 +0200
Newsgroups gmane.linux.mandrake.expert.russian
Organization Ukr-Com
Message-ID <20050208090828.7a122b64@winsor>
> [root@localhost ignat]# telnet localhost 3306
> Trying 127.0.0.1...
> Connected to localhost (127.0.0.1).
> Escape character is '^]'.
> +
> 4.0.18-log6^X|*Y`X,Connection closed by foreign host.
>=20
> =FC=D4=CF =CF=CE =CB=CF=CE=C5=CB=D4=C9=D4=D3=D1 =C9=CC=C9 =CE=C5=D4?

=CB=CF=CE=CE=C5=CB=D4=C9=D4=D3=D1 =C9 =DA=C1=D0=D5=DD=C5=CE.


> > mysql> connect mysql
> > 3.insert into user values('%','some_user','',"=CE=C1 =D7=D3=C5 =D0=D2=
=C9=D7=C9=CC=C5=C7=C9=C9 =D5=D3=D4=C1=CE=C1=D7=CC=C9=D7=C1=C5=CD Y");
> > 4.insert into db values('%','some_base','some_user',"=CE=C1 =D7=D3=C5 =
=D0=D2=C9=D7=C9=CC=C5=C7=C9=C9 =D5=D3=D4=C1=CE=C1=D7=CC=C9=D7=C1=C5=CD Y");
> > 5.=C9 =CE=C5 =DA=C1=C2=D9=D7=C1=C5=CD =D0=CF=CD=C5=CE=D1=D4=D8 =D0=C1=
=D2=CF=CC=D8 =DE=C5=D2=C5=DA =C1=C4=CD=C9=CE. =CC=C9=C2=CF =D7 =D4=CF=CD =
=D6=C5 insert =D5=CB=C1=DA=C1=D4=D8 =D7 3-=C5 =D0=CF=CC=C5 =DA=C1=DD=C9=C6=
=D2=CF=D7=C1=CE=CE=D9=CA =D0=C1=D2=CF=CC=D8.
> > =CD=D9 =D3=CF=DA=C4=C1=CC=C9 =C2=C1=DA=D5 some_base, =C9 =D0=CF=CC=D8=
=DA=CF=D7=C1=D4=C5=CC=D1 some_user, =CB=CF=D4=CF=D2=D9=CA =CD=CF=D6=C5=D4 =
=D3=CF=C5=C4=C9=CE=D1=D4=D3=D1 =D3 =DC=D4=CF=CA =C2=C1=DA=CF=CA =D3 =CC=C0=
=C2=CF=C7=CF =C8=CF=D3=D4=C1 =D3=CF =D7=D3=C5=CD=C9 =D0=D2=C1=D7=C1=CD=C9 =
=CE=C1 =DC=D4=D5 =C2=C1=DA=D5.

> mysql> connect some_base

=CE=C5 some_base =C1 mysql - =D3=C9=D3=D4=C5=CD=CE=C1=D1 =C2=C1=DA=C1 =D3 =
=C4=C1=CE=CE=D9=CD=C9 =CF =D0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=D1=C8, etc. =D5=
 =CD=C5=CE=D1 =D4=C1=CB =C9 =CE=C1=D0=C9=D3=C1=CE=CF.

>=20
> mysql> insert into user values('%','ign1111','',"=CE=C1 =D7=D3=C5 =D0=D2=
=C9=D7=C9=CC=C5=C7=C9=C9
> =D5=D3=D4=C1=CE=C1=D7=CC=C9=D7=C1=C5=CD Y");
> ERROR 1146: Table 'somebase.user' doesn't exist
=D3=C1=CD=CF =D3=CF=C2=CF=CA, =D4=C1=C2=CC=C9=C3=C1 user =C5=D3=D4=D8 =D7 =
=C2=C1=DA=C5 mysql, =C1 =CE=C5=D4 =D7 some_base.
=C1 "=CE=C1 =D7=D3=C5 =D0=D2=C9=D7=C9=CC=C5=C7=C9=C9 =D5=D3=D4=C1=CE=C1=D7=
=CC=C9=D7=C1=C5=CD Y" =C9=CD=C5=CC=CF=D3=D8 =D7 =D7=C9=C4=D5 =DE=D4=CF =CE=
=D5=D6=CE=CF =D0=CF=DE=C9=D4=C1=D4=D8 =C4=CF=CB=D5=CD=C5=CE=D4=C1=C3=C9=C0 =
=D7 =D2=C1=DA=C4=C5=CC=C5 =E2=C5=DA=CF=D0=C1=D3=CE=CF=D3=D4=D8, =C9 =D0=CF=
=D3=CD=CF=D4=D2=C5=D4=D8 =D7 =D4=C1=C2=CC=C9=C3=D5 user =C9 =D3=D4=CF=CC=C2=
=C3=D9, =CF=D4=D7=C5=DE=C1=C0=DD=C9=C5 =DA=C1 =D0=D2=C9=D7=C9=CC=C5=C7=C9=
=C9 =D5=D3=D4=C1=CE=CF=D7=C9=D4=D8 =D7 Y. =F7=D3=C5 =D0=C5=D2=C5=DE=C9=D3=
=CC=D1=D4=D8 =D0=CF=CC=D1 - =D5 =CD=C5=CE=D1 =D5=D3=D4=C1=CE=C5=D4 =D2=D5=
=CB=C1....

>=20
> =E9 =DE=D4=CF =C4=C1=CC=D8=DB=C5?
=DE=C9=D4=C1=C5=CD =CF=DE=C5=CE=D8 =D0=CC=CF=D4=CE=CF =CD=C1=CE=D5=C1=CC (=
=CF=DE=C5=CE=D8 =C8=CF=D2=CF=DB=C9=CA, =CB=D3=D4=C1=D4=C9) =C9=C4=D5=DD=C9=
=CA =D7 =C4=C9=D3=D4=D2=C9=C2=D5=D4=C9=D7=C5!!!!!!!!!!!!!!!!!

>=20
> =EB=D3=D4=C1=D4=C9, =C1 =CB=C1=CB =D0=D2=CF=D3=CD=CF=D4=D2=C5=D4=D8, =CB=
=C1=CB=C9=C5 =D0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=C9 =C4=CF=D3=D4=D5=D0=CE=D9,=
 =C1 =D4=CF =D1 =D4=C1=CB=20
connect mysql
select * from user;
delete from user where user=3Dignat;
>=20
> [ignat@localhost ignat]$ mysqlshow
> +-----------+
> | Databases |
> +-----------+
> | test      |
> +-----------+
>=20
> =F0=C5=D2=D7=D9=C8 =C4=D7=D5=C8 =C2=C1=DA =CE=C5 =D7=C9=C4=C9=D4. =EE=C5 =
=C8=CF=D2=CF=DB=CF =DC=D4=CF.
=D3=C1=CD=CF =D3=CF=C2=CF=CA!!!!!!!!!!!! =C9=DA=D5=DE=C1=C5=CD =D4=CF=CE=CB=
=CF=D3=D4=C9 =C6=C1=CA=CC=CF=D7=CF=CA =CF=D2=C7=C1=CE=C9=DA=C1=C3=C9=C9 =C0=
=CE=C9=CB=D3 (=D0=D2=C1=D7 =C4=CF=D3=D4=D5=D0=C1) - =CF=DE=C5=CE=D8 =DA=C1=
=CE=C9=CD=C1=D4=C5=CC=D8=CE=C1=D1 =D7=C5=DD=D8.


=E1 =D7=CF=CF=C2=DD=C5 - =D0=D2=C5=D6=C4=C5 =DE=C5=CD =D0=C9=D3=C1=D4=D8 =
=D7 expert =C9 =DA=C1=C4=C1=D7=C1=D4=D8 =D4=C1=CB=C9=C5 =D7=CF=D0=D2=CF=D3=
=D9 - =CE=C1=C4=CF =C2=D9 =D0=CF=DE=C9=D4=C1=D4=D8 =CD=C1=CE=D5=C1=CC =D0=
=CF mysql =C9 =C5=D3=D4=D8 =D0=CF=D4=D2=D1=D3=CE=C1=D1, =CF=C2=C1=CC=C4=C5=
=CE=CE=C1=D1 =D3=D4=C1=D4=D8=D1=20
http://ln.com.ua/~openxs/articles/smart-questions-ru.html
--=20
WINS1-UANIC