Maybe you should read a bit about MariaDB and it's history before being so dismissive of it. To save you a bit of effort:kamilosxd678 wrote: ↑Sun Dec 10, 2017 10:15 pmI have perfectly working solutions for one and true MySQL and I never wanted this cheap replacement shoved down my throat.
It could be argued that MariaDB is the true MySQL (with what's called MySQL being the product of Oracles takeover dealings).MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.
Code: Select all
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mysql-server-5.5 mysql-client-5.5 mysql-workbench
Because that's wrong. As the OP pointed out, MySQL is not available in Raspbian Stretch.JorgeP wrote: ↑Tue Dec 12, 2017 12:28 pmNot sure which Pi you are using or what version of raspbian you have. I have a Pi 3 with the latest raspbian and MySQL is available, it;s about 150-200mb from what it looks like for me. Both client and server.
don't know why nobody just told you instead of ranting about what they feel is better, although you could have found this out by doing a few searches.Code: Select all
sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server-5.5 mysql-client-5.5 mysql-workbench
Code: Select all
apt-cache policy mysql-server-5.5 mysql-client-5.5
Are you sure you're running the Raspbian Jessie?JorgeP wrote: ↑Tue Dec 12, 2017 12:28 pmNot sure which Pi you are using or what version of raspbian you have. I have a Pi 3 with the latest raspbian and MySQL is available, it;s about 150-200mb from what it looks like for me. Both client and server.
don't know why nobody just told you instead of ranting about what they feel is better, although you could have found this out by doing a few searches.Code: Select all
sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server-5.5 mysql-client-5.5 mysql-workbench
Code: Select all
[email protected]:~$ apt-cache policy mysql-server-5.5
mysql-server-5.5:
Installed: (none)
Candidate: (none)
Version table:
Yes, current Jessie. I purchased an nRF52 Dev board and tried installing the arm development software, somehow I ended up with "Synaptic Package Manager" I saw mysql and installed it. I forgot that step until I took the screenshot, I forgot that I didn't install MySQL from the command line.Are you sure you're running the Raspbian Jessie?
AFAICT these packages are not in the Stretch repo
That's not the latest Raspbian release!
Code: Select all
[email protected]:~ $ lsb_release -a
No LSB modules are available.
Distributor ID: Raspbian
Description: Raspbian GNU/Linux 9.1 (stretch)
Release: 9.1
Codename: stretch
'mfa298 wrote:That's not the latest Raspbian release!
(and that's not been updated for a month or so).Code: Select all
[email protected]:~ $ lsb_release -a No LSB modules are available. Distributor ID: Raspbian Description: Raspbian GNU/Linux 9.1 (stretch) Release: 9.1 Codename: stretch
Jessie (the previous release of Debian/Raspbian) has the original MySQL as bought out by Oracle, Stretch (the latest release of Debian/Raspbian) has switched to the fully opensource variant (as have most Linux Distributions) which is maintained by the original author of MySQL and is forked from just before Oracle got their hands on it.
I'm using HeidiSQL (on Windows) without problems. And other programs manipulating data don't have any problems either...pcmm wrote: ↑Thu Jul 05, 2018 12:14 amI'm struggling with this also. I keep reading that Mariadb " is a drop in relpacement" not sure how people are saying this! the default mariadb install in stretch is just junk! To date (been working on this for a few weeks off and on) I have yet to find a gui client that works with it, and all my php pages that were working perfectly in Jessie, don;t work at all in stretch, they can't connect to the database at all. Mariadb is so secure, nothing connects to it!
I don't have any experience with MySQL or MariaDB on the Pi, but I have been a long-time user of MySQL for websites hosted on my main (Windows) system and on my ISP's (Unix) server. About nine months ago the ISP decided that they were going to switch to MariaDB, so I switched locally, and I have seen no problems or incompatibilities. phpMyAdmin continues to work as it did before (without reinstallation), as does my custom PHP code, some of which is quite complex. Unless others are having problems with MariaDB on the PI (entirely possible), I would be looking for something specific to your circumstances.pcmm wrote: ↑Thu Jul 05, 2018 12:14 amI'm struggling with this also. I keep reading that Mariadb " is a drop in relpacement" not sure how people are saying this! the default mariadb install in stretch is just junk! To date (been working on this for a few weeks off and on) I have yet to find a gui client that works with it, and all my php pages that were working perfectly in Jessie, don;t work at all in stretch, they can't connect to the database at all. Mariadb is so secure, nothing connects to it!
Its probably both! but I can't get any gui cllient I've tried to connect the only client that can connect is the built in mysql cli clientDirkS wrote: ↑Thu Jul 05, 2018 12:28 amI'm using HeidiSQL (on Windows) without problems. And other programs manipulating data don't have any problems either...pcmm wrote: ↑Thu Jul 05, 2018 12:14 amI'm struggling with this also. I keep reading that Mariadb " is a drop in relpacement" not sure how people are saying this! the default mariadb install in stretch is just junk! To date (been working on this for a few weeks off and on) I have yet to find a gui client that works with it, and all my php pages that were working perfectly in Jessie, don;t work at all in stretch, they can't connect to the database at all. Mariadb is so secure, nothing connects to it!
Are you sure it's a MariaDB problem and not a PHP5 vs PHP7 issue?
Are these local connections (from the same Pi) or remote (from another computer)