Thinking I'm going to get a second RPi. They're addictive. And like potato chips, you can't have just one.
Does anyone run MySQL on a RPi? Server. If so, I'm thinking it might make a great platform to play with and get my feet wet with MySQL. Years ago I used to program in Visual FoxPro and some MS SQL Server, but I'm really rusty.
Is there a MySQL version/package that's recommended? Any gotchas with running an external drive via USB? Any words of wisdom about this idea?
-
- Posts: 25280
- Joined: Tue Mar 25, 2014 12:40 pm
- Location: Delightful Dorset
Re: Anyone run MySQL on a RPi 3+?
Mtl_Biker wrote: ↑Wed Jun 12, 2019 3:13 pmThinking I'm going to get a second RPi. They're addictive. And like potato chips, you can't have just one.
Does anyone run MySQL on a RPi? Server. If so, I'm thinking it might make a great platform to play with and get my feet wet with MySQL. Years ago I used to program in Visual FoxPro and some MS SQL Server, but I'm really rusty.
Is there a MySQL version/package that's recommended? Any gotchas with running an external drive via USB? Any words of wisdom about this idea?
Yes MySQL / MariaDB has been extensively posted about over the last 7 years. Many blogs and tutorials on this subject !
Last edited by fruitoftheloom on Wed Jun 12, 2019 3:52 pm, edited 1 time in total.
The information is out there....you just have to let it in.
My other Linux machine is a ChromeBox
My other Linux machine is a ChromeBox
Re: Anyone run MySQL on a RPi 3+?
It's MariaDB now instead of MySQL, but yes, I do run it on a 3B+. I also run the older MySQL on a couple of Pi 2Bs, one of which has a couple of servers running MariaDB slaves off it.
Unreadable squiggle
Re: Anyone run MySQL on a RPi 3+?
Great! Thanks guys. I'd never heard of MariaDB (I haven't touched programming in years) and I'm going to look into it. And I'm ordering another RPi today to install it on (for playing and learning).
Cheers!
Cheers!
-
- Posts: 14048
- Joined: Fri Mar 09, 2012 7:36 pm
- Location: Vallejo, CA (US)
Re: Anyone run MySQL on a RPi 3+?
MariaDB is a fork of MySQL that was started after Oracle bought MySQL. As I understand it, there is much more active development work taking place on MariaDB than on MySQL. The general interfaces are the same, though that souldn't be an issue to some new to either DBMS.
And isn't it cute that you are getting your second Pi..

Re: Anyone run MySQL on a RPi 3+?
I just installed MariaDB on my RPi 3B+ running Raspbian Lite.
All you have to do is:
You can then log in:
There is no password, so just press enter.
/Mogens
All you have to do is:
Code: Select all
sudo apt-get install mariadb-server
Code: Select all
sudo mysql -u root -p -h localhost
/Mogens
Re: Anyone run MySQL on a RPi 3+?
Thank you! That's very helpful!deepo wrote: ↑Thu Jun 13, 2019 9:05 pmI just installed MariaDB on my RPi 3B+ running Raspbian Lite.
All you have to do is:You can then log in:Code: Select all
sudo apt-get install mariadb-server
There is no password, so just press enter.Code: Select all
sudo mysql -u root -p -h localhost
/Mogens
But just to confirm... you've installed MariaDB, but you log in with sudo MYSQL?
Re: Anyone run MySQL on a RPi 3+?
That is correct. MariaDB and MySQL are compatible. The Opensource community were unhappy with Oracle taking over MySQL, so they forked an earlier version of the code, updated it and renamed it MariaDB. (That's a simplified version, but essentially what happened).
Pretty much any code that uses MySQL can use MariaDB with no changes. The command line client kept the same name for compatibility. You can type "mariadb" instead of "mysql" if you want. It will still work and still give a "MySQL" prompt.
Unreadable squiggle