Page 1 of 1

Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Sun Oct 16, 2016 5:27 pm
by 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?

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Sun Oct 16, 2016 6:48 pm
by DougieLawson
sudo apt-get -y mariadb-server mariadb-client

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

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Mon Oct 17, 2016 2:04 am
by stevelloyd88
DougieLawson wrote: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.

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Mon Oct 17, 2016 5:02 am
by 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

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Mon Oct 17, 2016 1:20 pm
by 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.

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Wed Oct 19, 2016 8:48 am
by 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

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Sat Mar 04, 2017 4:44 pm
by 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

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Fri Sep 15, 2017 3:10 pm
by 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)

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Fri Sep 15, 2017 4:12 pm
by DougieLawson
Raspbian Stretch includes MariaDB 10.1 which has everything in MySQL 5.7 plus a bunch more.

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Sun Mar 04, 2018 5:28 pm
by c0ff3e
DougieLawson wrote:
Fri Sep 15, 2017 4:12 pm
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.

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Posted: Sun Mar 04, 2018 7:12 pm
by DougieLawson
c0ff3e wrote:
Sun Mar 04, 2018 5:28 pm
DougieLawson wrote:
Fri Sep 15, 2017 4:12 pm
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).

MySQL 5.7 Docker Container for Raspberry Pi using Debian Sid

Posted: Mon Jul 16, 2018 8:14 am
by 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