RE: how to change the user's password in mysql. - Mark Peoples - com.mysql.lists.plusplus

5 messages in com.mysql.lists.plusplusRE: how to change the user's password...

From	Sent On	Attachments
cool...@21cn.com	17 Jul 2001 18:42
cool...@21cn.com	17 Jul 2001 18:42
Leonard Thornton	17 Jul 2001 18:49
Mark Peoples	17 Jul 2001 20:01
Greg Haley (aka gregor)	18 Jul 2001 04:03

Subject:	RE: how to change the user's password in mysql.
From:	Mark Peoples (mar...@ex1.hostmydot.com)
Date:	07/17/2001 08:01:44 PM
List:	com.mysql.lists.plusplus

or, try it with just -p ... it should ask for the password on stdin

eg, /usr/bin/mysqladmin -u root -p <enter>

marco

-----Original Message----- From: Leonard Thornton [mailto:leon...@intelis-inc.net] Sent: Tuesday, July 17, 2001 6:50 PM To: cool...@21cn.com; "Trem" <loh...@iie-evry.fr.to>;pavel matula Cc: plus...@lists.mysql.com Subject: Re: how to change the user's password in mysql.

It only seems to work if you supply the password on the command line:

/usr/bin/mysqladmin -u root -password 'password'

On Tue, 17 Jul 2001, cool...@21cn.com wrote:

hi! on redhat 7.1 , i install mysql: #rpm -i MySQL-3.23.39-1.i386.rpm #rpm -i MySQL-client-3.23.39-1.i386.rpm

it's successful. and then i run: #/usr/bin/mysqladmin -u root -password /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)'

#/usr/bin/mysqladmin -h localhost -u root -password rootpw /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)'

it's not successful.

and then i run: # /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.39

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

it's successful.

HOW TO CHANGE THE USER's password ('ROOT')? please help me. thanks

------------------------------- ÇÀ×¢ÉÌÎñÓÊ£¬ÊÖ»úµ½ÎÒÊÖ http://enterprise.21cn.com/game/