Error when uprading to Mysql 5.5.40

abdelhost77

• November 11, 2014 12:06

Upgrade from Mysql 5.1 to 5.5 seems to be OK, Mysql is started, sites are working, phpmyadmin is OK and shows that installed version is 5.5 . mysql -V mysql Ver 14.14 Distrib 5.5.40, for Linux (x86_64) using readline 5.1 But in upgrade logs ( var/cpanel/logs) i found below errors . i dont know if it is an issue ? [20141111.105019] Running 'mysql_fix_privilege_tables'... [20141111.105019] ERROR 1644 (45000) at line 1151: Multiple accounts exist for @user_name, @host_name that differ only in Host lettercase; remove all except one of them [20141111.105019] ERROR 1062 (23000) at line 1157: Duplicate entry 'php%-n32mxth4' for key 'PRIMARY' [20141111.105019] FATAL ERROR: Upgrade failed [20141111.105021] Starting MySQL[ OK ] [20141111.105026] MySQL55-test-5.5.40-1.cp1136 [20141111.105028] compat-MySQL51-shared-5.1.73-4.cp1136 [20141111.105029] MySQL55-devel-5.5.40-1.cp1136 [20141111.105030] MySQL55-shared-5.5.40-1.cp1136 [20141111.105032] Prelinking shared libraries and binaries: /usr/sbin/prelink -av -mR [20141111.105119] Checking for and running RPM::Versions 'post' hooks for any RPMs just installed [20141111.105119] All required 'post' hooks have been run

• 

  cPanelMichael

  • November 12, 2014 13:32

  Hello :) Those messages should not result in any problems, but you may want to address them to ensure those databases and usernames operate properly. The message is documented under "mysql_upgrade" here: [url=http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-21.html]MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.21 (2014-09-23) Thank you.

  0

Please sign in to leave a comment.