Has anyone had success installing Mysql 8 on a RPI? Mysql 8 has json_table function and I would love to use that to insert records in bulk.
I have looked around but cannot find a mysql 8 installer for debian arm.
1 Answer
sudo apt-get install software-properties-common -y
sudo add-apt-repository ppa:lars-tangvald/mysql-8.0
sudo apt-get update
sudo apt-get install mysql-server
It consumes more memory than MySQL 5
SWAP required.
Since the authentication method has also been changed, please edit the following.
sudo vi /etc/mysql/my.cnf
[mysqld]
default_authentication_plugin=mysql_native_password
-
1You don't need change authentication. You need update your users|passwords. It is not good information and it is also bad practice.abkrim– abkrim2019-02-03 19:32:49 +00:00Commented Feb 3, 2019 at 19:32
-
seems this does not work anymore: add-apt-repository ppa:lars-tangvald/mysql-8.0 gives "could not find a distribution template for Raspbian/stretch"Steve Lloyd– Steve Lloyd2019-03-17 05:22:18 +00:00Commented Mar 17, 2019 at 5:22
-
It worked for Ubuntu Server but installed 5.7Matt Rek– Matt Rek2020-11-05 17:35:47 +00:00Commented Nov 5, 2020 at 17:35
mysql-serverwill install mariaDB on Stretch. If you want the latest version you are using the wrong OS as Debian is very conservative, so you will need to install from some external source.