MySQL Bugs: #61176: Migration from 5.1.X to 5.5.9

Bug #61176	Migration from 5.1.X to 5.5.9 - 12
Submitted:	14 May 2011 11:15	Modified:	31 Mar 2014 11:04
Reporter:	Tomasz Maciejewski	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Config Wizard	Severity:	S3 (Non-critical)
Version:	5.5.12	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	regression

Description:
I uninstalled old version of MySQL. I restarted OS and installed 5.5.12 version.
Config wizard with modify security settings is always fail (in part apply sercurity settings).

Firewall is turned off.

Error no: 1045
Access denied for root@localhost

I am I write good password.
In version 5.5.8 this bug didn't appear

How to repeat:
-Install MySQL 5.1.X
-UnInstall MySQL 5.1.X
-Instal 5.5.12
-Run Config wizard
  Standard configuration
  Modify security settings
     retype root password
  Commit
  Fail

See bug #60552 also.

I think this can be related to new column added mysq.user table in 5.5. See bug #59038.

Do you check options for anonimous login or root login from remote machines during installation?

Yes, I checked for remote login. I need it.

Please, try to add/re-configure server instance without adding login for root from remote machines. You can add it later manually. It can be a useful workaround (if it works).

OK, but it is workaround.
I am planning to upgrade several MySQL servers and it will be inconvenient.
This issue will be fixed?

I've asked you check if this workaround solves the problem to confirm my idea of what the problem is. 

Surely, this has to be fixed: installer/config. wizard should do whatever is needed to work without problems when upgrading from 5.1.x to 5.5.x in the same data directory.

Yes, If property "Enable root access from remote machine" is not checked, then wizard config is finished successfully.

So, looks like the problem is related to config. wizard trying to insert/update row in mysql.user table (inherited from 5.1.x) without checking that its structure is correct for 5.5.x. 

Probably related to new 5.5 column(s) like:

 plugin                 | char(60)

Thank you for the bug report. We are closing this report now since the original config wizard is no longer the focus of Windows deployment efforts. For recent MySQL Server versions, the config wizard is also no longer available, and the MySQL Installer for Windows is the recommended way to install MySQL Server on Windows.