MySQL Bugs: #36527: Query Execute Thread cannot connect to MySQL

Bug #36527	Query Execute Thread cannot connect to MySQL
Submitted:	6 May 2008 12:29	Modified:	15 May 2008 13:02
Reporter:	Shawn Downs	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.12	OS:	Other (Windows Vista)
Assigned to:		CPU Architecture:	Any

Description:
I created a user account for myself to use. I gave this user all privileges to the schema I am building. After putting dummy data into a table called clients, I tried to Query the table (select * from clients;) and got the following error:

Query Execute Thread cannot connect to MySQL

I tried to get on the computer hosting the db and, using my account, got the same result. I can log onto root and query the table fine. I am not sure if this means anything but I removed the "Execute" privilege and got the same error, not an error stating that my account doesn't have the proper privileges. I am sure that I am overlooking something silly but I can't find my error. Thanks in advance! 

How to repeat:
Log on to any query browser using the account that I created and gave all privileges to for the schema in question. And type in any query that works using the root account.

Thank you ofr the bug report. Could you please see bug: http://bugs.mysql.com/bug.php?id=28629 and verify max_user_connections had been reached. Thanks in advance.

Thank you for your time in this matter!!! I have fixed the issue by adjusting the max_user_connections from 1 -> 2. Could you please explain why that would create an issue.

Thank you for the feedback. To understand better this behavior please enable
the --log option of the server start and then you will see that QB creates
(by design) a new connection for each query. There is already a feature request
to change this behavior. Thanks in advance.