Re: MySQL

Andrey N. Kobluk =D0=C9=DB=C5=D4:
>>[root@localhost ignat]# mysqladmin -u root password root
>>mysqladmin: connect to server at 'localhost' failed
>>error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>>
>>
>>>     /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <p=
assword>
>>
>>[root@localhost ignat]# mysqladmin -u root -h `localhost` password root
>>bash: localhost: command not found
>>mysqladmin: connect to server at 'password' failed
>>error: 'Unknown MySQL Server Host 'password' (2)'
>>Check that mysqld is running on password and that the port is 3306.
>>You can check this by doing 'telnet password 3306'
>=20
> =CD=CF=D6=CE=CF =D0=CF=D0=D2=CF=C2=CF=D7=C1=D4=D8 =C2=C5=DA -h `localho=
st`
> # mysqladmin -u root password root
> # mysql -u root -p
> Enter password:root
> mysql>
> =DC=D4=CF =D3 mysql, =D5=D3=D4=C1=CE=CF=D7=CC=C5=CE=CE=CF=CA =D3 =CE=D5=
=CC=D1.
> telnet localhost 3306 =D7=CF=CF=C2=DD=C5 =CB=CF=CE=CE=C5=CB=D4=C9=D4=D3=
=D1? =DA=C1=D0=D5=DD=C5=CE =CC=C9 mysql =D7=CF=CF=C2=DD=C5?

[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.

=FC=D4=CF =CF=CE =CB=CF=CE=C5=CB=D4=C9=D4=D3=D1 =C9=CC=C9 =CE=C5=D4?

mysql =D7=D2=CF=C4=C9 =DA=C1=D0=D5=DD=C5=CE, =D0=CF=D4=CF=CD=D5, =DE=D4=CF=
 =D7=D9=C4=C1=A3=D4 =D3=CC=C5=C4=D5=C0=DD=C5=C5:

[ignat@localhost ignat]$ mysqladmin version
mysqladmin  Ver 8.40 Distrib 4.0.18, for mandrake-linux-gnu on i586
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          4.0.18-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 7 min 28 sec

Threads: 1  Questions: 3  Slow queries: 0  Opens: 6  Flush tables: 1
Open tables: 0  Queries per second avg: 0.007

>>=E4=CC=D1 =D0=CF=C4=D3=CF=C5=C4=C9=CE=C5=CE=D1 =CB =D3=C5=D2=D7=C5=D2=D5=
 =CD=CE=C5 =CE=D5=D6=CE=CF =DA=CE=C1=D4=D8 hostname =C9=CC=C9 =C1=C4=D2=C5=
=D3,=20
>>=D0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=D1 =CF=D4 =C9=CD=C5=CE=C9 =CB=CF=D4=CF=
=D2=CF=C7=CF =D1 =D0=CF=C4=D3=CF=C5=C4=C9=CE=D1=C0=D3=D8 =CB =C2=C1=DA=C5=
 =C9 =C5=C7=CF =D0=C1=D2=CF=CC=D8.=20
>>=EC=D5=DE=DB=C5 =DE=C5=D2=C5=DA =CB=CF=CE=D3=CF=CC=D8. =E2=D9=CC=C1 =C2=
=C1=DA=C1 test =D1 =C5=A3 =CB=CF=CD=C1=CE=C4=C1=CD=C9 =D5=D3=D0=C5=DB=CE=CF=
 =D5=C4=C1=CC=C9=CC, =C1 =D7=CF=D4=20
>>=D3=CF=DA=C4=C1=D4=D8 =CE=CF=D7=D5=C0 =CE=C5 =CD=CF=C7=D5:
>=20
> =FC=C8=C8=C8....
> 1. =F0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=C5=CD root=20
> [root@winsor winsor]# mysql -u root -p
> Enter password:=20
> mysql> create database some_base;
> Query OK, 1 row affected (0.00 sec)
> mysql>=20
> 2. =D3=CF=C5=C4=C9=CE=D1=C5=CD=D3=D1 =D3 =D3=C9=D3=D4=C5=CD=CE=CF=CA =C2=
=C1=DA=CF=CA
> 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.

[root@localhost ignat]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 180 to server version: 4.0.18-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>  create database some_base;
Query OK, 1 row affected (0.07 sec)

mysql> connect some_base
Connection id:    182
Current database: somebase

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

=E9 =DE=D4=CF =C4=C1=CC=D8=DB=C5?

[root@localhost ignat]# mysqlshow -p
Enter password:
+-----------+
| Databases |
+-----------+
| mysql     |
| some_base |
| test      |
+-----------+

=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
=D0=CF=C4=CF=DA=D2=C5=D7=C1=C0, =DE=D4=CF =D0=CF =CB=D2=C1=CA=CE=C5=CA =CD=
=C5=D2=C5 =C4=D7=C1 root =C9 ignat, =C9 =CB=C1=CB =D7=D4=CF=D2=CF=C7=CF =D5=
=C4=C1=CC=C9=D4=D8,=20
=C1 =D4=CF:

[ignat@localhost ignat]$ mysqlshow
+-----------+
| Databases |
+-----------+
| test      |
+-----------+

=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.


> =C1 =D7=CF=CF=C2=DD=C5 - =D4=C1=CB=C9 =D0=D2=CF=DD=C5 =D0=CF=D3=D4=C1=D7=
=C9=D4=D8 gui - =DE=D4=CF=C2=D9 =D0=CF=CE=C9=CD=C1=D4=D8 =DE=D4=CF =D7=CF=
=CF=C2=DD=C5 =C4=C5=CC=C1=C5=D4=D3=D1 =D3 =D0=D2=C1=D7=C1=CD=C9 =D7=C9=DA=
=D5=CC=D8=CE=CF...

=F0=CF=D3=D4=C1=D7=C9=CC, =CB=C1=CB=D5=C0-=D4=CF =C7=D5=A3=D7=C9=CE=D5, =D2=
=D5=C7=C1=C5=D4=D3=D1, =DE=D4=CF =C1=CB=C3=C5=D3 =C4=C5=CE=C9=C5=C4...