2

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.

  • 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 4 '18 at 4: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 mariadb.com/kb/en/library/connect-json-table-type – Rob Bricheno Nov 4 '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 5 '18 at 11:18
0
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
  • 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 3 '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 5:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.