Re: MySQL

On Sun, 06 Feb 2005 02:35:24 +0200
Ignatiy Goloviznin <[email protected]> wrote:

> [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)'
>=20
> >      /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password <pa=
ssword>
>=20
> [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'

=CD=CF=D6=CE=CF =D0=CF=D0=D2=CF=C2=CF=D7=C1=D4=D8 =C2=C5=DA -h `localhost`
# 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?

=20
> =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:

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

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

--=20
WINS1-UANIC