Ubuntu – MySQL 5.5 Update to MySQL 5.7

14.04MySQLupgrade

I searched a tutorial for dummies, about how to Update my MySQL 5.5 Server to MySQL 5.7 I'm Using ubuntu 14.04. I've already tried the tutorials on the MySQL Website. How can I upgrade my server?

Best Answer

This worked for me:

wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb
sudo gdebi mysql-apt-config_0.8.10-1_all.deb
sudo apt-get update
sudo apt-get install mysql-server

The 2nd command will ask for input:

enter image description here

After picking 5.7 choose "apply"

$ mysql --version
mysql  Ver 14.14 Distrib 5.7.8-rc, for Linux (x86_64) using  EditLine wrapper

Don' forget to run mysql_upgrade after installation to upgrade system tables and restart server, following MySQL Upgrading guide.

$ mysql_upgrade

or

$ sudo mysql_upgrade -u root -p

And restart mysql

sudo service mysql restart
Related Question