3

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.

Steve Lloyd
  • 177
  • 1
  • 8
  • What exactly is your question. mysql-server will 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. – Milliways Nov 04 '18 at 04:41
  • Note that the version of MariaDB available in the current Raspbian distribution also supports JSON tables so you don't need MySQL to use this feature https://mariadb.com/kb/en/library/connect-json-table-type/ – Rob Bricheno Nov 04 '18 at 22:37
  • 1
    MariaDB may have JSON table support but it does not have the JSON_TABLE function. This function is available in Mysql 8 – Steve Lloyd Nov 05 '18 at 11:18

1 Answers1

1
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
user96484
  • 34
  • 2
  • 1
    You don't need change authentication. You need update your users|passwords. It is not good information and it is also bad practice. – abkrim Feb 03 '19 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 Mar 17 '19 at 05:22
  • It worked for Ubuntu Server but installed 5.7 – Maciek Rek Nov 05 '20 at 17:35