MySql 5.5 is the default version for Ubuntu 14.04
Steps to Upgrade the mysql-server
If you have existing database in Mysql 5.5. It should be migrated automatically.
Take the backup of existing databases:
mysql> mysqldump --lock-all-tables -u root -p -all-databases > backup.sql
Uninstall the existing Mysql-server with this command:
sudo apt-get remove mysql-server*
Installation of MySql5.6
MySql 5.6 is available in the default repositories:
Sudo apt-get update Sudo apt-get install mysql-server-5.6 Sudo apt-get install mysql-client-5.6 mysql-client-core-5.6
To restore the specific databases:
mysql -u root -p < backup.sql
Webner Solutions is a Software Development company focused on developing CRM apps (Salesforce, Zoho), LMS Apps (Moodle/Totara), Websites and Mobile apps. If you need Web development or any other software development assistance please contact us at webdevelopment@webners.com