Re: MySQL

Andrey N. Kobluk =D0=C9=DB=C5=D4:
> from manual.txt
>  If you are installing MySQL for the first time, *please remember to se=
t
> a password for the MySQL `root' user!*
>=20
> This is done with the following two commands:
>=20
>      /usr/local/mysql/bin/mysqladmin -u root password <password>

[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 <pa=
ssword>

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

>>=E9 =D3=D2=C1=DA=D5 =C5=DD=A3 =D7=CF=D0=D2=CF=D3=C9=CB, =CB=C1=CB =DA=C1=
=C4=C1=D4=D8 Database server hostname, =D0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=D1=
=20
>>=C9 =C5=C7=CF =D0=C1=D2=CF=CC=D8?
>=20
> =D5=D4=CF=DE=CE=C9=D4=C5 =D7=CF=D0=D2=CF=D3, =D0=CF=D6=C1=CC=D5=CA=D3=D4=
=C1.
> =CD=CF=D6=CE=CF =DE=C5=D2=C5=DA =C7=D5=C9 =C1=C4=CD=C9=CE. =CD=CF=D6=CE=
=CF =DE=C5=D2=C5=DA mysqladmin, =CD=CF=D6=CE=CF =DE=C5=D2=C5=DA mysql_set=
permission =C9 =CE=C1=CB=CF=CE=C5=C3  - =D3=C1=CD=D9=CA =C3=C9=CE=D5=D3 -=
 =DE=C5=D2=C5=DA =CB=CF=CE=D3=CF=CC=D8 =D5=D0=D2=C1=D7=CC=C5=CE=C9=D1 =DA=
=C1=D0=D2=CF=D3=C1=CD=C9 select =C9 update =D7 =C2=C1=DA=C5 mysql.

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

[ignat@localhost ignat]$ mysqladmin drop test
[ignat@localhost ignat]$ mysqlshow
+-----------+
| Databases |
+-----------+
+-----------+
[ignat@localhost ignat]$ mysqladmin create ign
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:=20
'@localhost' to database 'ign''

[root@localhost ignat]# mysqladmin create ign
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'