| Bug #16253 | 2 users root created after installation | ||
|---|---|---|---|
| Submitted: | 6 Jan 2006 14:34 | Modified: | 12 Jan 2006 20:33 |
| Reporter: | Mickael Besson | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 4.1.16 | OS: | Windows (Windows XP pro SP2) |
| Assigned to: | CPU Architecture: | Any | |
[6 Jan 2006 18:07]
MySQL Verification Team
Looking at: http://dev.mysql.com/doc/refman/4.1/en/default-privileges.html "On Windows, prior to MySQL 4.1.10, two root accounts are created; one of these is for connecting from the local host and the other allows connections from any host. Beginning with MySQL 4.1.10, the Windows installer creates only one root account, which can connect from the local machine only." The last phrase should be completed with: If user checks to enable root for to connect from remote host, then two root counts are created. Also for to remove the root@localhost account should be done as a post installation procedure: http://dev.mysql.com/doc/refman/4.1/en/windows-post-installation.html
[12 Jan 2006 20:33]
Mike Hillyer
With the latest 4.1.16 the installer behaved according to the documentation, creating two accounts. Note that this was a clean install. I did add a note that two accounts are created when the option is checked, as per Miguel's suggestion.
Description: If during the installation you choose "Enable root access from remote machine", two users root will be created (two rows in table 'user') : mysql> select host, user from user where user like('root'); +-----------+------+ | host | user | +-----------+------+ | % | root | | localhost | root | +-----------+------+ -> root on localhost would not be created, only on %. How to repeat: - Run setup and active "Enable root access from remote machine". - Finish setup - Type on mysql client : mysql> select host, user from user where user like('root'); Suggested fix: Delete root on localhost if this option is activated.