| Bug #6219 | Incorrect instruction for Windows users on MySQL Manual 2.4.3 | ||
|---|---|---|---|
| Submitted: | 22 Oct 2004 18:26 | Modified: | 22 Oct 2004 19:08 |
| Reporter: | Stuart Russel | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | MySQL Reference Manual for version 4.0.2 | OS: | Windows (Microsoft Windows) |
| Assigned to: | CPU Architecture: | Any | |
[22 Oct 2004 18:58]
Paul DuBois
What version of MySQL do you have?
[22 Oct 2004 19:08]
Paul DuBois
This is a similar problem to that reported earlier: http://bugs.mysql.com/bug.php?id=6000 The problem is that the build accounts were included by mistake in some Windows distributions.
[25 Oct 2004 3:04]
Stuart Russel
Okay, so you need more version information in addition to "4.0.2" which I wrote in my original bug report's version field: "Version: MySQL Reference Manual for version 4.0.2". I downloaded mysql-4.0.20d-win-noinstall.zip and I tried to install MySQL manually by following the steps described in the manual included in mysql-4.0.20d-win-noinstall.zip. That was my first time installing MySQL. Before I posted this bug report, I had read "User Comments" section of MySQL Manual section 2.4.3 in the following page: http://dev.mysql.com/doc/mysql/en/Default_privileges.html
Description: I doubt that the description in MySQL Manual section 2.4.3 is correct for Windows users. How to repeat: The following commands in MySQL Manual section 2.4.3 did not work on my Microsoft Windows 2000 computer: mysql> SET PASSWORD FOR ''@'%' = PASSWORD('newpwd'); mysql> SET PASSWORD FOR 'root'@'%' = PASSWORD('newpwd'); Suggested fix: I suggest the following for Windows users to set passwords for initial MySQL accounts: Setting passwords for root user accounts: > SET PASSWORD FOR 'root'@'localhost' = PASSWORD('<new password>'); > SET PASSWORD FOR 'root'@'build' = PASSWORD('<new password>'); Setting passwords for anonymous user accounts: > SET PASSWORD FOR ''@'localhost' = PASSWORD('<new password>'); > SET PASSWORD FOR ''@'build' = PASSWORD('<new password>');