From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: From: Dmitry Kovalsky Organization: IMBG To: community@altlinux.ru Subject: Re: [Comm] Mysql root password Date: Mon, 29 Mar 2004 21:55:24 +0200 User-Agent: KMail/1.5 References: <200403291923.51954.dikov@imbg.org.ua> <20040329203254.2e920d93.michael@michael.rsuh.ru> In-Reply-To: <20040329203254.2e920d93.michael@michael.rsuh.ru> MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200403292255.24530.dikov@imbg.org.ua> X-AVP-RU: Passed X-BeenThere: community@altlinux.ru X-Mailman-Version: 2.1.4 Precedence: list Reply-To: community@altlinux.ru List-Id: Mailing list for ALT Linux users List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 29 Mar 2004 19:55:29 -0000 Archived-At: List-Archive: List-Post: On Monday 29 March 2004 19:32, Michael Bykov wrote: > On Mon, 29 Mar 2004 18:23:51 +0200 > > Dmitry Kovalsky 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