“Do not pre-install or pre-configure any additional packages on your OS. The installer expects a freshly installed, supported, OS, and anything you do differently may cause conflicts or configuration errors. If you will be enabling third-party package repositories, do so after installation of Virtualmin, and only with extreme caution.”
If you must change to different packages, you must do it after installation of Virtualmin.
One question at a time, please. Opcache is completely unrelated to MySQL. And, Mariadb is not going to make your apps faster than MySQL.
I should be clear, I strongly recommend you stick with the default packages, if you don’t know what you’re doing. There is no significant difference between MySQL and MariaDB, in terms of performance or much of anything else.
But, if you must (though I don’t think you should):
Install Virtualmin. Don’t run the config check, yet.
Then install MariaDB.
Then run the following, as root:
virtualmin config-system --include MySQL
Then login to Virtualmin and run the setup wizard and config check, as usual, which should allow you to set a root password for the database.
That’s it. Probably. But, if you don’t have a good reason to do it, then don’t.
That’s not a plugin in config-system. I said MySQL. We treat the two databases almost identically, because they are almost identical. In most places in Virtualmin Mariadb and MySQL are also treated identically, again, because they are almost identical and most users never need to care which one they have except to know what the service is named.
What are you doing? I thought you wanted mariadb? Why are you going backward, you’re making this so complicated.
What do you mean it didn’t work? I see an error about mariadb not being able to start, which is unusual, but the wizard may have been able to correct it…but not once you started purging packages. You may need to figure out why mariadb won’t start.
Obviously if you uninstall MySQL and MariaDB Virtualmin it’s going to complain about MySQL being missing (again, Virtualmin treats them almost identically).
Your instructions didnt work on ubuntu 20.04- i got that error. I never removed mysql since instructions didnt said to remove. Wizzard didnt correct. Its Digitalocean ubuntu 20.04. Ill try now with debian.
MySQL does not appear to be installed and running on your system, or has not yet been set up properly in Webmin’s MySQL Database module. If your system does not use MySQL, it should be disabled in Virtualmin’s module configuration page.
As I mentioned, you may need to figure out why mariadb won’t start. I assumed installing mariadb would remove/stop mysql, but maybe it doesn’t. If it doesn’t mysql is squatting on the port (they’re almost identical, and use the same port, by default).
To be clear, I’m not telling you to guess why it won’t start and start randomly doing things. I want you to look in the journal and mysql/mariadb logs to see what’s going on, and take the necessary actions to resolve the problem.
It does.
I had a few minutes to spare to test this (work is slow tonight).
The problem at hand seems to be some apparmor stuff, but as I don’t use Ubuntu (then by default not apparmor either) I don’t know how to easily overcome that one and get mariadb started.
There were some “apparmor: denied” messages when trying to start mariadb.
I don’t remember the exact wording of the message though, and I’ve already purged the test instance.
I was mostly curious to see if it worked, but since I don’t use Ubuntu I can’t say I was too heavily invested.
