mysql 5.1 to mysql 5.5

Upgrading from MySQL 5.1 to MySQL 5.5 / 5.6 when there is existing data is quite head-cache and scary story. Some notes might also help you when do upgrading: After upgrading, we need to run mysql_upgrade. In order to do that, we must have the mysql service running[bash]mysqld –skip-grant-tables –user=mysql mysql_upgrade -u root -p’PASSWORD'[/bash] If mysql…