[linux] MySQL - o co ide ? (Access denied ...)

[Ing. Jaroslav Matej, PhD.]

Ahoj,

Heslo root-a v MySQL som nenastavaval, v doc pisu ze nema byt ziadne (po 
instalacii). Zohnal som si knizku 'Myslime v MYSQL 4' od Gilfillan-a. Aj 
tak to nejde, nechapem. Prikladam vypis z postupu:

-----VYPIS Z KONZOLY-----
[root na localhost jaro]# /etc/rc.d/init.d/mysql stop
Zastavuje sa MySQL server
(pid 3982)050203 08:00:37  mysqld ended

                                                             [   OK    ]
[1]+  Done                    mysqld_safe --skip-grant-tables
[root na localhost jaro]#
[root na localhost jaro]#
[root na localhost jaro]#
[root na localhost jaro]# ps ax | grep mysql
  4022 pts0     S      0:00 grep mysql
[root na localhost jaro]#
[root na localhost jaro]# mysqld_safe --skip-grant-tables &
[1] 4035
[root na localhost jaro]# Starting mysqld daemon with databases from 
/var/lib/mysql
[root na localhost jaro]# mysqladmin -u root password '*****'
mysqladmin: unable to change password; error: 'You must have privileges 
to update tables in the mysql database to be able to change passwords 
for others'
[root na localhost jaro]#
-----KONIEC VYPISU Z KONZOLY-----

MJ
--

Peter Gašparovič wrote:
> Ahoj,
> 
> root ma nastavene heslo a preto musis pustit prikaz s parametrom -p
> mysqlshow -p
> system si nasledne vypyta heslo roota v mysql (pozor nemusi to byt nutne 
> to iste heslo ktore ma root v systeme, ale kedze podla tvojho mailu je 
> to nastavene instalaciou, tak je mozne, ze je to rovnake heslo).
> To iste plati aj napr o prikaze mysql, cize mysql -p .
> 
> Peter
>