MySQL Bugs: #56608: MySQL Workbench 5.2CE/ MySQL Server5.1 Accounts/ Add User

Bug #56608	MySQL Workbench 5.2CE/ MySQL Server5.1 Accounts/ Add User
Submitted:	7 Sep 2010 10:21	Modified:	12 Jun 2012 10:46
Reporter:	David Rodenburg	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S5 (Performance)
Version:	5.2.27 CE, 5.2.38	OS:	Windows (Windows 7 Professional 32-bit)
Assigned to:		CPU Architecture:	Any

Description:
Cannot add a User Account
(With server running)
Add User button/Apply button in Accounts returns Message Box
"Unhandled exception" OR 
"Unhandled exception": "None Type" object has no attribute "nextRow"

How to repeat:
Build a Schema
Create an Server Instance
Select Accounts, Server Access Management
Click "Add Account" button
Select "Login", Admin Roles, Account Limits
Click "Apply" 
Error: "Unhandled exception" OR
"Unhandled exception": "None Type" object has no attribute "nextRow"

What exact version, 5.2.x, do you use?

Q.[7 Sep 15:23] Valeriy Kravchuk What exact version, 5.2.x, do you use?

A. MySQL Workbench 5.2 CE from the properties box
   Nothing indicates a version "5.2.x"

Installer package was 5.2.27

What exact operating system do you run Workbench on and what exact server version, 5.1.x, are you working with?

Windows 7 Professional 32-bit
MySQL server version: mysql-essential-5.1.50-win32
I am trying to use MySQL server/Workbench in a local host environment
I found that these errors are associated with local host instance
When selecting a TCP/IP connection I can:
-Connect to my local host machine (seems like this is reverse of what I would expect)and
-Make and save admin. edits

I couldn't repeat on Vista Ultimate 64-bit.

Please, check if the same problem still happens with a newer version of Workbench, 5.2.28.

If I install 5.2.28 will my files and schema be wiped out?
What can I do to "import" my database and schema(s) to the new version?

Installation of 5.2.28 (Complete) should NOT remove any schemata or .mwb/.sql files created or reverse engineered, neither it will change anything on servers you worked with. Just Workbench binaries and libraries will be replaced with a newer version.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I get this error fairly often under "Users and Privileges" after making a change in Schema Privileges tab, then going back to Server Access Management tab and clicking on a user. Once it gets into this broken mode, clicking any user in the list gets this error. 

Traceback (most recent call last):
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_security.py", line 1067, in user_selected
    self.owner.secman.async_get_user_schema_privs(self.show_user, user)
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_security_be.py", line 391, in async_get_user_schema_privs
    privileges.load(user)
  File "/Applications/MySQLWorkbench.app/Contents/PlugIns/wb_admin_security_be.py", line 461, in load
    while result.nextRow():
AttributeError: 'NoneType' object has no attribute 'nextRow'
MySQL Workbench CE for Mac OS X version 5.2.38  revision 8753
Configuration Directory: /Users/srogers/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.9.1
OS: Darwin 11.3.0
CPU: 8x Intel(R) Core(TM) i7-2675QM CPU @ 2.20GHz, 16.0 GB RAM

Steve,

What exact server version, 5.x.y, are you working with?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm running server version 5.1.61

Does this still happen with the latest version? If so, can you attach the log file at
C:\Users\<your user id>\AppData\Roaming\MySQL\Workbench\wb.log ?

Note: The log file must be taken right after you repeat the error and quit WB.

I tried reproducing it under the latest version and couldn't. Maybe it's fixed.

I tried reproducing it under the latest version and couldn't. Maybe it's fixed.

Not repeatable with 5.2.40 it seems.

This Bug seems not to be fully fixed in "MySQL Worbench V 5.2.44CE".

(Worked in MySQL Workbench with Admin Privileges via UAC)
I wanted to reset a Password of a user and instantly got this type of Error message.
After some minutes of bug searching here on mysql.com I wanted to try again.
Then it seems to be that there was a "timeout" for the wohle "User and Privileges" "Dialog/Management". I couldn't Use/Access it anymore in MySQL Workbench.
So I restartet MySQL Workbench - then resetting a User Passwort for example was possible again.

My environment:
"fully local environment"
OS: Win7x64Pro "Version 6.1.7601 Service Pack 1 Build 7601"
MySQL-Server: 5.5.16
MySQL-Workbench: 5.2.44CE

Still occurs in 6.0.8.11354 build 833

Screenshot with error

Attachment: Screen Shot 2014-04-17 at 11.53.54 AM.png (image/png, text), 17.81 KiB.

Error replicated.

Attempted to access a user with full privileges on MySQL 6.1 for Mac OS X (32-bit)
Version 6.1.4.11773 build 1454

Server is on CentOS:
5.5.36-cll-lve
MySQL Community Server (GPL) by Atomicorp
Compiled for: Linux   (x86_64)
Version: CentOS release 6.5 (Final)
centos-release-6-5.el6.centos.11.2.x86_64
Socket: /var/lib/mysql/mysql.sock

Connected to server via SSH tunnel.

Quick work-around
Waiting for the connection to time out, then reconnecting allows access to the table data.

(Sorry for the double-post, the system wouldn't allow me to attach a screenshot to this post.)