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