Updating mysql version

To perform a major version upgrade for a My SQL version 5.5 DB instance on Amazon RDS to My SQL version 5.6 or later, you should first perform any available OS updates.

After OS updates are complete, you must upgrade to each major version: 5.5 to 5.6, and then 5.6 to 5.7.

Once the option says mysql-5.7, scroll down on the main menu to Apply and press ENTER again. 5.7), which is not a supported upgrade path as documented by mysql.

The easiest way around this is to upgrade mysql to 5.6 whilst still under 14.04. ) dumping all your databases; hostname # mysqldump --lock-all-tables -u root -p --all-databases then upgrading to mysql 5.6; hostname # apt-get install mysql-server-5.6 mysql-client-5.6 mysql-server-core-5.6 mysql-client-core-5.6 This way, all your databases are upgraded in place and (on my machines so far) entirely safely and transparently to 5.6.

If you want to install My SQL 5.7, you'll need to add the newer APT package repository from the My SQL APT repository page.

Click Download on the bottom right, then copy the link on the next page from No thanks, just start my download. You'll see a prompt that asks you which My SQL product you want to configure.

The My SQL Server option, which is highlighted, should say mysql-5.7.

If it doesn't, press ENTER, then scroll down to mysql-5.7 using the arrow keys, and press ENTER again.You can see my comment that the solution by @Rinzwind did not worked in my case (Ubuntu 14.04 , Mysql 5.5).So i have googled the solution and found the answer which worked for me at Digital Ocean Tutorial. I am pasting the particular portion of tutorial that worked for me .When you are ready, you can perform version upgrades at the times that best fit your schedule.If your DB instance is using read replication, you must upgrade all of the Read Replicas before upgrading the source instance.If your DB instance is in a Multi-AZ deployment, both the primary and standby DB instances are upgraded.

Comments are closed.