- stevelloyd88
- Posts: 10
- Joined: Sun Oct 16, 2016 5:23 pm
Install Mysql 5.7 on raspbian jesse - pi 3
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
- Posts: 40820
- Joined: Sun Jun 16, 2013 11:19 pm
- Location: A small cave in deepest darkest Basingstoke, UK
- Contact: Website Twitter
Re: Install Mysql 5.7 on raspbian jesse - pi 3
sudo apt-get -y mariadb-server mariadb-client
That gets you Maria DB which is the more modern version of MySQL.
That gets you Maria DB which is the more modern version of MySQL.
Any language using left-hand whitespace for syntax is ridiculous
Any DMs sent on Twitter will be answered next month.
Fake doctors - are all on my foes list.
Any requirement to use a crystal ball or mind reading will result in me ignoring your question.
Any DMs sent on Twitter will be answered next month.
Fake doctors - are all on my foes list.
Any requirement to use a crystal ball or mind reading will result in me ignoring your question.
- stevelloyd88
- Posts: 10
- Joined: Sun Oct 16, 2016 5:23 pm
Re: Install Mysql 5.7 on raspbian jesse - pi 3
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.DougieLawson wrote: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
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
There is a change to the compile at 5.7.5. https://dev.mysql.com/doc/relnotes/mysq ... 5-7-5.html
- stevelloyd88
- Posts: 10
- Joined: Sun Oct 16, 2016 5:23 pm
Re: Install Mysql 5.7 on raspbian jesse - pi 3
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.
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
-
- Posts: 1
- Joined: Wed Oct 19, 2016 8:35 am
Re: Install Mysql 5.7 on raspbian jesse - pi 3
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
ps : the package libevent-core-2.0-5 is needed now for mysql-server
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
-
- Posts: 1
- Joined: Mon Sep 03, 2012 8:07 pm
Re: Install Mysql 5.7 on raspbian jesse - pi 3
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
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
The links about don't work, I've browsed the 5.7 directorys and grabbed the armhf.debs doing the following;
However, I received the following errors;
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)
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
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.
(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
- Posts: 40820
- Joined: Sun Jun 16, 2013 11:19 pm
- Location: A small cave in deepest darkest Basingstoke, UK
- Contact: Website Twitter
Re: Install Mysql 5.7 on raspbian jesse - pi 3
Raspbian Stretch includes MariaDB 10.1 which has everything in MySQL 5.7 plus a bunch more.
Any language using left-hand whitespace for syntax is ridiculous
Any DMs sent on Twitter will be answered next month.
Fake doctors - are all on my foes list.
Any requirement to use a crystal ball or mind reading will result in me ignoring your question.
Any DMs sent on Twitter will be answered next month.
Fake doctors - are all on my foes list.
Any requirement to use a crystal ball or mind reading will result in me ignoring your question.
Re: Install Mysql 5.7 on raspbian jesse - pi 3
No there is no data type json support in that version of mariaDB, so there are things missing.DougieLawson wrote: ↑Fri Sep 15, 2017 4:12 pmRaspbian Stretch includes MariaDB 10.1 which has everything in MySQL 5.7 plus a bunch more.
10.2.7 is the first release with it.
- DougieLawson
- Posts: 40820
- Joined: Sun Jun 16, 2013 11:19 pm
- Location: A small cave in deepest darkest Basingstoke, UK
- Contact: Website Twitter
Re: Install Mysql 5.7 on raspbian jesse - pi 3
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).c0ff3e wrote: ↑Sun Mar 04, 2018 5:28 pmNo there is no data type json support in that version of mariaDB, so there are things missing.DougieLawson wrote: ↑Fri Sep 15, 2017 4:12 pmRaspbian Stretch includes MariaDB 10.1 which has everything in MySQL 5.7 plus a bunch more.
10.2.7 is the first release with it.
Any language using left-hand whitespace for syntax is ridiculous
Any DMs sent on Twitter will be answered next month.
Fake doctors - are all on my foes list.
Any requirement to use a crystal ball or mind reading will result in me ignoring your question.
Any DMs sent on Twitter will be answered next month.
Fake doctors - are all on my foes list.
Any requirement to use a crystal ball or mind reading will result in me ignoring your question.
MySQL 5.7 Docker Container for Raspberry Pi using Debian Sid
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