Removing MariaDB
For a school project, we have to work with MySQL. I have managed to install the MySQL Workbench program with rpm-ostree. No issues running it.
The problem is trying to install mysql-server. Bazzite comes with mariadb-server by default and it cannot be installed alongside mysql-server because they share certain dependencies. I know mariadb is a fork of mysql, but I can't figure out how to connect it to the MySQL Workbench so I just want to get rid of it.
I cannot, for the life of me, figure out how to remove mariadb (or why it's there in the first place).
Any help would be greatly appreciated.
EDIT: I managed to connect. For anyone else in a similar situation, the solution for me was:
- Run mariadb as root.
sudo mariadb -u root -p
Run the following commands, and swap the password for the one you want to use.
GRANT ALL PRIVILEGES on . to 'root'@'localhost' IDENTIFIED BY '<password>'; FLUSH PRIVILEGES;
Restart the mariadb service
sudo service mariadb restart
Doing these steps allowed me to connect to the local database with MySQL.