ionewbie
By:
ionewbie

mysql 5.7.x on Ubuntu 14? (Lamp already installed)

December 5, 2014 26.4k views

hi,

I installed Lamp on Ubuntu 14, but i need mysql 5.7 to be installed.

Could anyone give an advice? Many thanks.

5 Answers

The DigitalOcean LAMP application uses the default version of MySql from Ubuntu 14.04 which is 5.5.40. MySql 5.7 is the development version and is not yet part of an official Ubuntu release.

You can install it directly from MySql though. To do so, run:

wget http://dev.mysql.com/get/mysql-apt-config_0.3.2-1ubuntu14.04_all.deb
sudo dpkg -i mysql-apt-config_0.3.2-1ubuntu14.04_all.deb
sudo apt-get update
sudo apt-get install mysql-server-5.7

Here's what I did:

wget http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.deb
sudo dpkg -i mysql-apt-config_0.6.0-1_all.deb
sudo apt-get update
sudo apt-get install mysql-server-5.7

Hi guys!

I'm just facing the same problem, need to upgrade a large mysql installation to 5.7. Everywhere they say that you need to upgrade to 5.6 before. Maybe that isn't necessary? Thanks:

Andras

use sudo apt-get install mysql-server instead of sudo apt-get install mysql-server-5.7.

trevorg and vijayoncomet1's solution worked for me without any issues, thanks.

I also had to run a mysql_upgrade command to get everything working afterwards (mysqldump was throwing up an error without doing so).

In total, here's what I did (where 'root' is whatever your mysql user is):

wget http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.deb
sudo dpkg -i mysql-apt-config_0.6.0-1_all.deb
sudo apt-get update
sudo apt-get install mysql-server
mysql_upgrade -u root -p --force

I also needed to restart mysql after doing the above. Here's how I did so on my machine:

sudo service mysql restart
Have another answer? Share your knowledge.