Bug #29216 Access Violation: user_info null values
Submitted: 19 Jun 2007 15:15 Modified: 28 May 2009 12:51
Reporter: Mr Wakazula Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.12 OS:Windows (XP Pro (SP2))
Assigned to: CPU Architecture:Any

[19 Jun 2007 15:15] Mr Wakazula 
Description:
The MySql Administrator will throw an 'Access Violation' if there are NULL values in the mysql.user_info table.

CONTEXT:
Query Browser v1.2.12
MySql Server v5.0.41

How to repeat:
a) Log into MySql Administrator as root
b) Click 'User Administration'
c) Under 'User Accounts' right click 'Add User'
d) MySql User='junk', Password='junk', Confirm Password='junk'
e) Click 'Apply Changes'

f) Log into MySql Query Browser as root
g) Execute the following query: 
REPLACE INTO mysql.user_info (user, full_name)VALUES('junk', 'full name');

h) Log into MySql Administrator as root
i) Click 'User Administration'
j) In the 'Description' field, type 'my description'
k) When you click 'Apply changes' you will receive an 'Access Violation'
[19 Jun 2007 15:39] Valeriy Kravchuk 
Thank you for a problem report. Please, send the results of:

show variables like 'sql_mode';

I can not repeat the behaviour described on my system, hence the request.
[19 Jun 2007 18:19] Mr Wakazula 
show variables like 'sql_mode';

<<RETURNS>>

STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
[19 Jun 2007 21:18] MySQL Verification Team 
MA Exception

Attachment: MA-exception.png (image/png, text), 91.63 KiB.
[19 Jun 2007 21:20] MySQL Verification Team 
Thank you for the bug report. Verified as described (see screen-shot attached).
[20 Jun 2007 14:55] Mr Wakazula 
Thanks Miguel.
[28 May 2009 12:51] Susanne Ebrecht 
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't fix this anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/