Hello,
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.
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.
Thanks!
Dan Ertman
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
