MySQL Authentication fails after Upgrade to Version 5.5
ERROR 1045 (28000): Access denied for user 'contentmanager'@'localhost' (using password: YES)
For fun I thought I'd reset the password:
GRANT ALL ON thecontent.* TO contentmanager IDENTIFIED by 'dfdfsdfdsfsdfsd';
ERROR 1470 (HY000): String 'contentmanager' is too long for user name (should be no longer than 16)
This is ridiculous that this new version has some bizarre 16 character username limit and not only that but it causes authentication to fail.
Apparently this is some new "feature" of MySQL and from what I understand it can't be turned off except by editing the source code and recompiling. This is simply not an option for production servers and a disaster when sites/databases/apps stop working after upgrading.
So the only quick solution is to create a new username that is less than 16 characters long and update your apps/config files.
Tags:
mysql, authentication, fails, upgrade, user, contentmanager, localhost, password, reset, thecontent, identified, dfdfsdfdsfsdfsd, hy, username, quot, feature, editing, recompiling, servers, sites, databases, apps, upgrading, characters, update, config,