Voici ma méthode issue de cette page http://xmodulo.com/upgrade-mysql-server … buntu.html.
J'ai remplacé les étapes 8-12 par mon étape 8.
Back up your MySQL config files.
$ sudo mkdir /backup
$ sudo tar cvfvz /backup/mysql_conf.tgz /etc/mysql
Export all databases to a .sql file, and back up MySQL data directory.
$ sudo sh -c 'mysqldump -u root -p -A --events > /backup/backup_db.sql'
$ sudo tar cvfvz /backup/mysql_data.tgz /var/lib/mysql
Stop MySQL server.
$ sudo service mysql stop
Uninstall and remove MySQL packages.
$ sudo apt-get remove mysql-server mysql-client mysql-common
$ sudo apt-get autoremove
$ sudo apt-get autoclean
Do not use "purge" option in apt-get as that would remove MySQL config files and other MySQL related data directories as well, which we will continue to use after MySQL upgrade.
Install MySQL dependency (kernel asynchronous I/O access library) which is needed for MySQL 5.5 and higher.
$ sudo apt-get install libaio1
Download a MySQL Debian package from the official site.
https://dev.mysql.com/downloads/repo/apt/
-> mysql-apt-config_0.8.3-1_all.deb
Install the downloaded MySQL package.
$ sudo dpkg -i mysql-apt-config_0.8.3-1_all.deb
Update
$ sudo apt-get update
$ sudo apt-get intall mysql-server
Start MySQL server.
$ sudo service mysql start
Restore MySQL databases.
$ sudo mysql -u root -p < /backup/backup_db.sql
Finally, upgrade MySQL system tables.
$ sudo /opt/mysql/server-5.6/bin/mysql_upgrade -v -u root -p
]]>