• Support

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

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

    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

      1. First, ensure you have a full backup of your databases.

      2. Completely uninstall MySQL from AAPanel:

        • Go to "Software Store" > "MySQL"
        • Click "Uninstall" and confirm

      3. Clean up any MySQL residual files:

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

      4. Remove MySQL from system services:

           systemctl disable mysqld
   systemctl stop mysqld

      5. Install MariaDB from AAPanel:

        • Go to "Software Store" > "MariaDB"
        • Choose your preferred version and install

      6. Verify the installation by running:

           mysql -V

        This should show the MariaDB version.

      7. 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

      8. 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)

      9. 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.