User avatar
stevelloyd88
Posts: 10
Joined: Sun Oct 16, 2016 5:23 pm

Install Mysql 5.7 on raspbian jesse - pi 3

Sun Oct 16, 2016 5:27 pm

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?

User avatar
DougieLawson
Posts: 34166
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Sun Oct 16, 2016 6:48 pm

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

That gets you Maria DB which is the more modern version of MySQL.
Microprocessor, Raspberry Pi & Arduino Hacker
Mainframe database troubleshooter
MQTT Evangelist
Twitter: @DougieLawson

2012-18: 1B*5, 2B*2, B+, A+, Z, ZW, 3Bs*3, 3B+

Any DMs sent on Twitter will be answered next month.

User avatar
stevelloyd88
Posts: 10
Joined: Sun Oct 16, 2016 5:23 pm

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Mon Oct 17, 2016 2:04 am

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.

peterlite
Posts: 720
Joined: Sun Apr 17, 2016 4:00 am

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Mon Oct 17, 2016 5:02 am

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

User avatar
stevelloyd88
Posts: 10
Joined: Sun Oct 16, 2016 5:23 pm

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Mon Oct 17, 2016 1:20 pm

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.

lucaspouchot
Posts: 1
Joined: Wed Oct 19, 2016 8:35 am

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Wed Oct 19, 2016 8:48 am

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
Posts: 1
Joined: Mon Sep 03, 2012 8:07 pm

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Sat Mar 04, 2017 4:44 pm

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
Posts: 1
Joined: Fri Sep 15, 2017 3:02 pm

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Fri Sep 15, 2017 3:10 pm

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)

User avatar
DougieLawson
Posts: 34166
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Fri Sep 15, 2017 4:12 pm

Raspbian Stretch includes MariaDB 10.1 which has everything in MySQL 5.7 plus a bunch more.
Microprocessor, Raspberry Pi & Arduino Hacker
Mainframe database troubleshooter
MQTT Evangelist
Twitter: @DougieLawson

2012-18: 1B*5, 2B*2, B+, A+, Z, ZW, 3Bs*3, 3B+

Any DMs sent on Twitter will be answered next month.

c0ff3e
Posts: 1
Joined: Sun Mar 04, 2018 5:26 pm

Re: Install Mysql 5.7 on raspbian jesse - pi 3

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.

User avatar
DougieLawson
Posts: 34166
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK
Contact: Website

Re: Install Mysql 5.7 on raspbian jesse - pi 3

Sun Mar 04, 2018 7:12 pm

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).
Microprocessor, Raspberry Pi & Arduino Hacker
Mainframe database troubleshooter
MQTT Evangelist
Twitter: @DougieLawson

2012-18: 1B*5, 2B*2, B+, A+, Z, ZW, 3Bs*3, 3B+

Any DMs sent on Twitter will be answered next month.

scito
Posts: 1
Joined: Mon Jul 16, 2018 8:09 am

MySQL 5.7 Docker Container for Raspberry Pi using Debian Sid

Mon Jul 16, 2018 8:14 am

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

Return to “Advanced users”