Description:
The documentation says that in order to change the root user's password, you
should run
C:\mysql\bin\mysqladmin -u root password your_password
I have tried this multiple times, on Windows 2000 and Windows XP, running
mysql as a service (mysql-max-nt), and it has had no effect on the root
user's password.
After running this command, with or without "mysqadmin -u root reload", I am
still able to:
1) Connect using "mysql mysql -u root"
2) Shut down using "mysqladmin -u root shutdown"
Fix:
I fixed the problem using
mysql mysql -u root
update user set password=PASSWORD('your_password') where user='root';
flush privileges;
However, this does not change the fact that mysqladmin appears to be bugged.
Submitter-Id: Dan Ertman
Originator: Dan Ertman
Organization: University of Pittsburgh
MySQL Support: none
Severity: serious
Priority: low
Category: mysqladmin
Class: sw/doc-bug
Release: MySQL 4.0.10.
Executable: mysql-max-nt running as a service
Environment: 1) Toshiba Laptop, 1.1 GHz PIII, 256 RAM, 30 GBHD.
2) Dell PowerEdge Server, dual 1.2 GHz P Xeon, 2 GB Ram, 200 GBHD
System: 1) Windows XP Home
2) Windows 2000 Server
Compiler: Binary distribution.
1 message in com.mysql.lists.win32mysqladmin password has no effect in ...