Install mysql (not mariadb) on raspbian bookworm and other debian
0
votes
0
answers
149
views
There are many servers in the network that I manage, and throughout that network, mysql is the standard and only "mysql-like" database used. (There's some postgre but that is another matter).
Today, I wanted to install mysql on a new server (rPi running bookworm) and was surprised that "mysql-client" and "mysql-server" are no longer candidates for the platform. Instead, it seems we're supposed to use
apt install default-mysql-client default-mysql-server
So I did that, and mariadb was installed. (I quickly removed it and the other products installed with it.) I've tried to search how to force this to mysql rather than mariadb, to no avail. I checked /etc/alternatives and that does not seem to be the thing in my way. My research has led me only to comments like "Just use mariadb - it'll work." But there's apparently no refund when that proves incorrect. :|
I know, mariadb is **meant to be** "almost completely" compatible with mysql. I don't need "almost" in this network. I need reliability and consistency.
I'm sure the key word here is "**default**"-mysql (the key word should be mysql - call it what it is) but I could find no way to set my preferred **default**. How can I install mysql and not mariadb on Bookworm and any other variants that try to force us away from mysql?
I get that there is SQL-level compatibility between Maria and MySql. But I'm more concerned about administration and what the NEXT change one or the other might make. Anyone with administrative experience will agree that maintaining two slightly dissimilar products is more than twice the effort from the standpoint that not only do you have to "know" both platforms, you also have to know the differences.
Asked by Dennis
(101 rep)
Mar 15, 2025, 06:03 PM
Last activity: Mar 16, 2025, 12:58 PM
Last activity: Mar 16, 2025, 12:58 PM