Install Mysql 5.7 on raspbian jesse - pi 3

[stevelloyd88]

I am trying to install Mysql 5.7 on my raspberri pi 3 running raspbian jesse. Has anyone does this before? Can you give me some pointers?

[DougieLawson]

sudo apt-get -y mariadb-server mariadb-client

That gets you Maria DB which is the more modern version of MySQL.

[stevelloyd88]

sudo apt-get -y mariadb-server mariadb-client

That gets you Maria DB which is the more modern version of MySQL.

Thanks, I was able to install it. however it seems that 10.0.27-MariaDB-0+deb8u1 (Raspbian) does not support "json" datatypes. I want mysql 5.7 for the json data type support.

[peterlite]

MySQL downloads, http://dev.mysql.com/downloads/mysql/#downloads, does not have an ARM version. There is the source code.

There is a change to the compile at 5.7.5. https://dev.mysql.com/doc/relnotes/mysq ... 5-7-5.html

[stevelloyd88]

I finally got it! It took me several hours and about 8 attempts but I got it. Here are the steps I took.
Thanks to https://solarianprogrammer.com/2016/06/ ... -programs/ and a lot of trial and error.

• apt-get update
  apt-get upgrade
  vi //etc/apt/sources.list
  change jesse to stretch
  apt-get update
  apt-get install gcc-6 g++-6
  vi /etc/apt/sources.list
  change stretch back to jesse
  apt-get update
  wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
  wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
  wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
  wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
  wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
  wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
  wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
  dpkg -i mysql-client-core-5.7_5.7.13-1~exp1_armhf.deb
  apt-get update
  apt-get install libaio1
  apt-get install libaio-dev
  dpkg -i mysql-client-core-5.7_5.7.13-1~exp1_armhf.deb
  dpkg -i mysql-client-5.7_5.7.13-1~exp1_armhf.deb
  apt-get install mysql-common
  dpkg -i mysql-client-5.7_5.7.13-1~exp1_armhf.deb
  dpkg -i mysql-server-core-5.7_5.7.13-1~exp1_armhf.deb
  dpkg -i mysql-server-5.7_5.7.13-1~exp1_armhf.deb
  apt-get install libmecab2
  apt-get install libhtml-template-perl
  dpkg -i mysql-server-5.7_5.7.13-1~exp1_armhf.deb
  apt-get upgrade
  dpkg --help
  dpkg --list
  dpkg --list mysql
  dpkg --help
  dpkg --search mysql
  dpkg --help
  dpkg -r mysql-server-5.7
  apt-get upgrade
  apt-get install libhtml-template-perl
  wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
  dpkg -i libmecab2_0.996-3_armhf.deb
  dpkg -i mysql-server-5.7_5.7.13-1~exp1_armhf.deb
  dpkg -r mysql-server-5.7
  wget http://ftp.debian.org/debian/pool/main/ ... +1_all.deb
  dpkg -i mysql-common_5.6.30-1~bpo8+1_all.deb
  dpkg -i mysql-server-5.7_5.7.13-1~exp1_armhf.deb

[lucaspouchot]

Thank you stevelloyd88 for your answer, today the version 5.7.13-1~exp1_armhf is no more on the debian pool
you should replace it by 5.7.15-1_armhf
Moreover, you should have to install liblz4-1 r127+
so, start with a

Code: Select all

wget http://ftp.debian.org/debian/pool/main/l/lz4/liblz4-1_0.0~r131-2_armhf.deb
dpkg -i liblz4-1_0.0~r131-2_armhf.deb

ps : the package libevent-core-2.0-5 is needed now for mysql-server

[fumblingWithIT]

You can get several versions of MySQL here: https://dev.mysql.com/downloads/repo/apt/ - Though I have not found any for arm yet...

I've boiled the above download list down to a fewer less command and update to current version 5.7.17-1:

wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
wget http://ftp.debian.org/debian/pool/main/ ... .2_all.deb
wget http://ftp.debian.org/debian/pool/main/ ... _armhf.deb
sudo apt install libaio1 libaio-dev libhtml-template-perl libevent-core-2.0-5
sudo dpkg -i libmecab2_0.996-3_armhf.deb
sudo dpkg -i liblz4-1_0.0~r131-2+b1_armhf.deb
sudo dpkg -i mysql-common_5.8+1.0.2_all.deb
sudo dpkg -i mysql-client-core-5.7_5.7.17-1_armhf.deb
sudo dpkg -i mysql-client-5.7_5.7.17-1_armhf.deb
sudo dpkg -i mysql-server-core-5.7_5.7.17-1_armhf.deb
sudo dpkg -i mysql-server-5.7_5.7.17-1_armhf.deb

[heronrob]

The links about don't work, I've browsed the 5.7 directorys and grabbed the armhf.debs doing the following;

Code: Select all

wget http://ftp.debian.org/debian/pool/main/m/mysql-5.7/libmysqlclient-dev_5.7.18-1+b1_armhf.deb
wget http://ftp.debian.org/debian/pool/main/m/mysql-5.7/libmysqlclient20_5.7.18-1+b1_armhf.deb
wget http://ftp.debian.org/debian/pool/main/m/mysql-5.7/libmysqld-dev_5.7.18-1+b1_armhf.deb
wget http://ftp.debian.org/debian/pool/main/m/mysql-5.7/mysql-client-5.7_5.7.18-1+b1_armhf.deb
wget http://ftp.debian.org/debian/pool/main/m/mysql-5.7/mysql-client-core-5.7_5.7.18-1+b1_armhf.deb
wget http://ftp.debian.org/debian/pool/main/m/mysql-5.7/mysql-server-5.7_5.7.18-1+b1_armhf.deb
wget http://ftp.debian.org/debian/pool/main/m/mysql-5.7/mysql-server-core-5.7_5.7.18-1+b1_armhf.deb

sudo dpkg -i libmysqlclient-dev_5.7.18-1+b1_armhf.deb
sudo dpkg -i libmysqlclient20_5.7.18-1+b1_armhf.deb
sudo dpkg -i libmysqld-dev_5.7.18-1+b1_armhf.deb

sudo dpkg -i mysql-client-5.7_5.7.18-1+b1_armhf.deb
sudo dpkg -i mysql-client-core-5.7_5.7.18-1+b1_armhf.deb
sudo dpkg -i mysql-server-5.7_5.7.18-1+b1_armhf.deb
sudo dpkg -i mysql-server-core-5.7_5.7.18-1+b1_armhf.deb

However, I received the following errors;

Code: Select all

dpkg: dependency problems prevent configuration of mysql-client-core-5.7:
 mysql-client-core-5.7 depends on liblz4-1 (>= 0.0~r130); however:
  Version of liblz4-1:armhf on system is 0.0~r122-2.
 mysql-client-core-5.7 depends on libstdc++6 (>= 5.2); however:
  Version of libstdc++6:armhf on system is 4.9.2-10.

I'm slightly burnt out today, so hopefully someone here can give me a nudge in the right direction?
(Originally I was trying to do master - master replication between rpi & ubuntu machines, only to realise after a week of configuring that 5.5 on the pi is not compatible, and the 5.5 install guide for ubuntu lead to dead ends, so now i'm trying to upgrade the pi)

[DougieLawson]

Raspbian Stretch includes MariaDB 10.1 which has everything in MySQL 5.7 plus a bunch more.

[c0ff3e]

Raspbian Stretch includes MariaDB 10.1 which has everything in MySQL 5.7 plus a bunch more.

No there is no data type json support in that version of mariaDB, so there are things missing.
10.2.7 is the first release with it.

[DougieLawson]

Raspbian Stretch includes MariaDB 10.1 which has everything in MySQL 5.7 plus a bunch more.

No there is no data type json support in that version of mariaDB, so there are things missing.
10.2.7 is the first release with it.

That's because of DebIan's insane package policy. You won't get MariaDB 10.2 or later until DebIan Buster. If you need a more agile, more current package you'll have to switch to Mint, Ubuntu or Arch (which aren't as conservative as DebIan).

[scito]

I successfully installed MySQL 5.7 into a Docker container and run it on Raspberry Pi 3. Details are in my blog post, see https://scito.ch/content/mysql-57-docke ... debian-sid