Unable to Switch from MySQL 8.0 to MariaDB on AAPanel – Help Needed

Kkolbaek · Sep 12, 2024

Hi everyone,

I'm encountering an issue with MariaDB on AAPanel. After uninstalling MySQL and installing MySQL 8.0.34, I’m unable to switch back to any version of MariaDB. Each time I attempt the switch, it seems to install correctly, but when I check the database version, it reverts back to MySQL 8.0. How can I resolve this issue and successfully switch to MariaDB?

Thanks in advance for any guidance!

Best Regards
Stig

aaPanel_Kern · Sep 13, 2024

Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:
Detailed problem description:

No post link will not be able to know which user's information is, and the problem will not be processed

kolbaek

AaaP_marrydavidm1 · Sep 13, 2024

First, ensure you have a full backup of your databases.
Completely uninstall MySQL from AAPanel:
- Go to "Software Store" > "MySQL"
- Click "Uninstall" and confirm

Clean up any MySQL residual files:

   rm -rf /www/server/mysql
   rm -rf /etc/my.cnf
   rm -rf /etc/init.d/mysqld

Remove MySQL from system services:

   systemctl disable mysqld
   systemctl stop mysqld

Install MariaDB from AAPanel:
- Go to "Software Store" > "MariaDB"
- Choose your preferred version and install

Verify the installation by running:

   mysql -V

This should show the MariaDB version.

If the problem persists:
- Check AAPanel logs for any error messages
- Ensure there are no conflicting packages installed
- Try installing MariaDB manually via command line

If manual installation is needed:

   sudo yum install mariadb-server
   sudo systemctl start mariadb
   sudo systemctl enable mariadb

(Commands may vary depending on your OS)

After manual installation, reconfigure AAPanel to recognize MariaDB:
- Go to "Software Store" > "MariaDB"
- Click "Setting" and ensure paths are correct

Remember to import your database backups after successful installation.

If you continue to face issues, it might be helpful to check the AAPanel error logs or consider reaching out to AAPanel support for more specific assistance.