upgrade mysql 5.5 to 5.6 ubuntu 14.04

Hi, Anyone now how to do this in linux via CLI SSH where commands are related with sudo yum update mysql-server full detail like above replies.

thanks

step 1 : take a backup

mysqldump --lock-all-tables -u root -p --all-databases > dump.sql

step 2 : remove old mysql

sudo apt-get remove mysql-server sudo apt-get autoremove

step 3 : install new version of mysql

sudo apt-get install mysql-client-5.6 mysql-client-core-5.6

sudo apt-get install mysql-server-5.6

step 4 : restore your data

mysql -u root -p < dump.sql

Please note!! If you just grabbed the DigitalOcean LAMP pre-built image and you are attempting to upgrade to MySQL 5.6 and getting this error at the end:

E: Sub-process /usr/bin/dpkg returned an error code (1)

It may simply be that you don’t have enough RAM. I was getting this error consistently on the low-end droplet with 512MB RAM and nothing worked except… with 1GB of RAM it finally worked. Here’s the simple sequence:

sudo apt-get update
sudo apt-get upgrade
sudo apt-get remove mysql-server
sudo apt-get autoremove
sudo apt-get install mysql-server-5.6

Try 1GB RAM!

Over and out.