MySQL Bugs: #25687: Can't manage user after upgrading MySQL to version 5.0.27-community-nt

Bug #25687	Can't manage user after upgrading MySQL to version 5.0.27-community-nt
Submitted:	17 Jan 2007 22:06	Modified:	31 Mar 2014 9:16
Reporter:	Luigi Sandon	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	1.2.8	OS:	Windows (Window XP/2000)
Assigned to:		CPU Architecture:	Any
Tags:	unscheduled

Description:
After upgrading from 4.1 to 5.0.27-community-nt I cannot manage user from MySQL Administrator. When clicking a user the user data tabs stay disabled. No error is returned. I can see the words "fetching user data" on the toolbar, but nothing happens. User context menu has clone and deleted disabled. Only add new user is active, when trying to create a new user I get:

"Error while storing the user information. The user might have been deleted.
Please refresh the user list.". A shell window appear with message:
"* Message: save user: error deleting old SP privileges"

The user is created anyway.

MySQL Server is running on a Windows 2000 Server SP4, all patches to date. My SQL Administrator tried on both the server with localhost connection, and on a XP SP2 (all patches to date), connected via TCP/IP.

Tried to install mysql-gui-tools-5.0-r8-win32.msi on both machines, same problem.

How to repeat:
Just try to manage users...

Thank you for the bug report. Have you applied the instructions to upgrade
from 4.1 to 5.0 mentioned in the Manual:

http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

otherwise could you please do and inform the results. Thanks in advance.

I followed the upgrade instruction and run mysqlupgrade, everything went smooth.

I could try to run it again with the -force parameter, and see what happens.

I run:

C:\Programmi\MySQL\MySQL50\bin>mysql_upgrade.exe -b C:\Programmi\MySQL\MySQL50 -d D:\db\mysql -u root -v
and after capturing the input in a file I got this error:

Could not find file mysql_fix_privilege_tables.sql
Please use --basedir to specify the directory where MySQL is installed

I can't find that file anywhere.

The script is not installed if "developer components" is unchecked while installing. I don't like to have dev things hanging around on a production machine. But that's an upgrade script, it should be installed separately from dev stuff.

After running the script a *couple of times* users can be edited again. Note the script looks strange: it attempts to alter proc_priv *before* creating it, for example, giving several message errors. Is it correct??

This looks similar to Bug #25515 Can't select a user in GUI Administrator

Yes is a duplicate of this bug.

It's just partly a duplicate: it is an installer bug IMHO. If you don't select "developers tools" you don't get a chance to upgrade MySQL correctly. An upgrade script is not a "developer tool", IMHO. The upgrade scripts should be installed always - or be in a separate install feature.

It is installer issue: mysql_fix_privilege_tables.sql should be installed
with any install option in my opinion. Thank you for the feedback.

Changed category as this does not belong to MA.

Posted by developer:
 
Thank you for the bug report. We are closing this report since MySQL Server 5.0 is an obsolete version of MySQL Server and the deployment technology has changed radically in later versions of MySQL Server.