MySQL Bugs: #48371: mysqlshow on Windows shouldn't default to ODBC

Bug #48371	mysqlshow on Windows shouldn't default to ODBC
Submitted:	28 Oct 2009 10:59	Modified:	28 Oct 2009 11:28
Reporter:	MC Brown	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Windows	Severity:	S3 (Non-critical)
Version:	5.1.39	OS:	Windows
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
If you install MySQL on Windows and then run mysqlshow, it defaults to trying to connect using the user 'ODBC'. 

Since we don't create this user by default during installation, and ODBC is not required to connect to MySQL on Windows, the use of the ODBC user by default is very confusing. 

How to repeat:
Install MySQL on Windows from any package. 

Run mysqlshow without any options, you'll get the error 'Access defined for user ODBC@localhost'
 

Suggested fix:
We should default to a different, more sensible user. This should either be the username of the current user (recommended) or 'root', since this is the one user that is created during installation.

Thanks MC, verified as described.