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,

Latest Articles

  • Cisco Unified Communications Manager / CUCM IP 8.6,10,12 Install Error Solution
  • Ubuntu Debian Mint Linux SSHD OpenSSH Server Not Starting After Reboot Solution
  • nmap how to scan for all ports and not just the 1000 most common ports
  • Windows 7,8,10 and Server 2008, 2012, 2016, 2019 Read Only Attribute Won't Go Away
  • bind / named how to make a wildcard record and retain defined A records
  • Cisco Unified Communications Manager 12 Install Errors on Proxmox/KVM
  • Local Vs Universally Administered MAC Address NIC Refuses to come up
  • Cisco Unified Communications Manager 12 CUCM 12 - How To Enable Video Calling
  • Windows 7, 8, 10, Windows Server 2008, 2012, 2016, 2019 How To AC97 Audio Drivers and Other Unsigned Drivers
  • Cisco Unified Communications Manager / CUCM IP Telephony Definitions
  • tftp Linux xinetd verbose logging
  • Linux delete unused tap devices automatically
  • Linux qemu-kvm How To Enable Soundcard in Guestl
  • QEMU-KVM Windows and Server Guest Installs Mouse Tracking Pointer Location Solution
  • SSH Keep Alive To stop Disconnections
  • Linux How To Disable SATA NCQ For Better Performance
  • the sign-in method you're trying to use isn't allowed. For more info, contact your network administrator - solution for active directory
  • gsmartcontrol for Windows to Check the SMART S.M.A.R.T status
  • WebRTC Vulnerability Shows Local IP Address Even When Using a Proxy or VPN Firefox Fix And Disable Solution
  • chroot in Linux Howto Simple and Easy Guide