Bug #5633 'mysqlshow mysql' results in access denied for user

• Submitted: 17 Sep 2004 19:03
• Modified: 1 Oct 2004 22:49
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S2 (Serious)
• Version: 4.0.20a-nt
• OS: Windows (Win 2000 SBS)
• CPU Architecture: Any

[17 Sep 2004 19:03] [ name withheld ]

Description:
I've installed MySQL and am now trying to verify the installation. mysqlshow works reasonably well; it doesn't return exactly the documented result, but it's close. Running 'mysqlshow mysql' results in 'mysqlshow: Access denied for user: '@localhost' to database 'mysql' ' . I have verified that all 4 user accounts are in place and have no passwords. I have added a 'hosts' file to both 'd:\windows\hosts' (the system drive is d:) and 'd:\WINNT\hosts'; the documentation just says to make the file '\windows\hosts' - not as useful as it could be. 

How to repeat:
mysqlshow mysql

[1 Oct 2004 22:49] MySQL Verification Team

That it is the expected behavior for a fresh install, even the root user having
an empty password it has provileges for to access the mysql database, then
you need to use the root user for.

c:\mysql\bin>mysqlshow -uroot mysql
Database: mysql
+--------------+
|    Tables    |
+--------------+
| columns_priv |
| db           |
| func         |
| host         |
| tables_priv  |
| user         |
+--------------+