Re: [Comm] Mysql root password

[Dmitry Kovalsky <dikov@imbg.org.ua>]

On Monday 29 March 2004 19:32, Michael Bykov wrote:
> On Mon, 29 Mar 2004 18:23:51 +0200
>
> Dmitry Kovalsky <dikov@imbg.org.ua> wrote:
> > привет
> > есть возможность както забить новый пароль рута в сабже?
> >
> > А то старый забыл и  не могу залогинится
>
> Это раздел в документации /usr/share/doc/MySQLxxx:
>
> A.4.2 How to Reset a Forgotten Root Password

 я могет чтото делаю не так но при попытке поменять пароль как описанно в 
мануале получаю 

[root@gwin conf.d]# /usr/libexec/mysqld --skip-grant-tables --user=mysql
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections

[root@gwin conf.d]# ps ax|grep mysql
13534 pts/6    S      0:00 /usr/libexec/mysqld --user=root --skip-grant-tables
13662 pts/4    S      0:00 grep mysql
[root@gwin conf.d]# mysqladmin -user=root password `ROOTPASSWD`
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'

или прав линухового рута не достаточно??

-- 
Sincerely yours,

Ph.D. Student Dmytro Kovalskyy
Institute of Molecular Biology & Genetics
150 Akad. Zabolotnogo Street,
Kiev-143, 03143
UKRAINE

E-mail: dikov@imbg.org.ua
Fax:  +380 (44) 266-0759
Tel.: +380 (44) 266-5589