Bug #23490 Server inst - users table created using MyISAM (br 1754)
Submitted: 20 Oct 2006 5:57 Modified: 24 Oct 2006 0:42
Reporter: Bill Weber Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Installing Severity:S1 (Critical)
Version:7.6 OS:Any (all)
Assigned to: Keith Russell CPU Architecture:Any

[20 Oct 2006 5:57] Bill Weber 
Description:
The Service Manager installation creates the "users" table in the Merlin db as a MyISAM table. Since foreign keys do not work with MyISAM tables, this breaks anything that references the users table (setting user preferences, creating network.mysql.com user accounts, etc.).

How to repeat:
see above

Suggested fix:
CREATE TABLE `users` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_name` varchar(255) NOT NULL,
  `user_pass` varchar(32) NOT NULL,
  `role_name` varchar(255) NOT NULL,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
[20 Oct 2006 6:01] Sloan Childers 
Looks like this may only be an issue on win32.
[23 Oct 2006 14:44] Keith Russell 
Reported by Bitrock as resolved in ver >= 7.9
[24 Oct 2006 0:42] Bill Weber 
Verified fixed in build 7.10.