yesterday i try to upgrade my DB from mysql5.0.22 to percona5.5.21
first i backup the data,and remove mysql5.0.22,install percona5.5.21,after start up ,i run mysql_upgrade to update system table,but failed
trade_lead_bak.trade1 OK
Running ‘mysql_fix_privilege_tables’…
ERROR 1370 (42000) at line 1111: alter routine command denied to user ‘root’@‘localhost’ for routine ‘mysql.die’
ERROR 1044 (42000) at line 1112: Access denied for user ‘root’@‘localhost’ to database ‘mysql’
ERROR 1370 (42000) at line 1125: alter routine command denied to user ‘root’@‘localhost’ for routine ‘mysql.die’
FATAL ERROR: Upgrade failed
but root@localhost can visit mysql,why???
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
i try this but failed
mysql> create procedure mysql.die() signal sqlstate ‘HY000’ set message_text=‘Unexpected content found in the performance_schema database.’;
ERROR 1044 (42000): Access denied for user ‘root’@‘localhost’ to database ‘mysql’