MySQL Bugs: #19870: provide more support for the 1045 Access Denied error

Bug #19870	provide more support for the 1045 Access Denied error
Submitted:	17 May 2006 8:06	Modified:	14 Jan 2009 13:50
Reporter:	Ralf Hauser	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S4 (Feature request)
Version:	1.1.20	OS:	Windows (winXP)
Assigned to:		CPU Architecture:	Any

Description:
When trying to login, I get

MySQL Error Number 1045

Access Denied for user 'userabc'@'hostx.tld' (using password: YES)

There is a ping button, but nothing else.

I contend that this and similar is one of the major headaches new users and newly setup DBs cause. A google search vastly documents this grief...

How about beyond the ping adding a diagnostic wizard or at least a html link that gives a cookbook approach how to recover from this without granting access to * - an unfortunate measure many users resort to in dispair...

How to repeat:
most users when accessing a DB for the first time...

Suggested fix:
tell the user (provided they also have access to the admin side)

- which log to look at to see more insight
- with SELECT Grant to execute to see the current access config

- show some case examples what the config and error message looked like and what steps it took to recover...

When getting into SSL, it gets even trickier!

See Bug #20899 for possible server-side feedback to a mysql client and 
Bug #21565 for what to add to the server-side err-log

Many thanks for writing a feature request. Connection access already is documented in our main documentation.