MySQL Bugs: #2161: Can't connect to database

Bug #2161	Can't connect to database
Submitted:	18 Dec 2003 12:04	Modified:	1 Jun 2004 0:33
Reporter:	Al Johnson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQLCC	Severity:	S2 (Serious)
Version:	0.9.4-beta	OS:	Windows (WinXP)
Assigned to:	Jorge del Conde	CPU Architecture:	Any

Description:
I believe the problem is that one cannot connect to a database unless they have the privilege to do a SHOW DATABASES, even if all "Show all databases" checkboxes are off and even if a database is explicitly specified.

How to repeat:
I have a MySQL database hosted on Blue Genesis. With 0.8.4, I can connect successfully even though I get an "Access denied for user" error. I have to specify the database explicitly, so I suspect the error comes from an attempt to do a SHOW DATABASES command. I probably don't have enough permissions to show all databases. With 0.9.4, I cannot connect and get the same "Access denied for user" error. I uncheck all the "Show all databases" checkboxes I can find, but the error persists. I manually entered the database, but still get "Access denied for user". The difference between 0.9.4 from 0.8.4 is that the connection is not made, so I can't access the DB.

With 0.9.4, if my username is "abcdefghijklmopqr", the exact error message is "Access denied for user: 'abcdefghijklmopq@123.123.123.123'". That is, the user name is truncated at 16 characters. (Note that the last "r" is missing.) I suspect this is only a display issue. The username is shown properly in the "Access denied" error message for 0.8.4.

I get the same problem. It works in 0.9.3 but not 0.9.4 I think the problem is truncation of the user ID. I too use bluegenesis qho mandate long user names.

Hi!

MySQLCC has been discontinued and will not be developed nor maintained anymore with the exception of Critical bugs.

In the near future we will release the substitute of MySQLCC called MySQL Query Browser.