Date:  Thu, 25 May 2006 19:22:33 +0200
From:  "RAQTweak.com" <bq (at mark) raqtweak.com>
Subject:  [coba-e:05390] Re: Changing mysql pass fails
To:  coba-e (at mark) bluequartz.org
Message-Id:  <20060525172151.M82857 (at mark) raqtweak.com>
In-Reply-To:  <010501c68020$d86d7a40$3701a8c0@lapxp>
References:  <010501c68020$d86d7a40$3701a8c0@lapxp>
X-Mail-Count: 05390

> I am trying to set mysql pass on BQ with the command:
> /usr/bin/mysqladmin --user=root password PASSWORD_GOES_HERE

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

I usually do this:
-----------------------
Alternatively, on any platform, you can set the new password using the mysql 
client(but this approach is less secure): 

Stop mysqld and restart it with the --skip-grant-tables --user=root options 
(Windows users omit the --user=root portion). 

Connect to the mysqld server with this command: 

shell> mysql -u root

Issue the following statements in the mysql client: 

mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
    ->                   WHERE User='root';
mysql> FLUSH PRIVILEGES;

Replace $BEO(Bewpwd” with the actual root password that you want to use. 

You should be able to connect using the new password. 
-----------------------


Best regards,
   Leslie Herps
   http://www.raqtweak.com/