Downgrade to MariaDB 10.4

eris · May 3, 2022, 2:52pm

Yes

backup all databases…

apt remove mariadb-client mariadb-common mariadb-server
apt purge mariadb-client mariadb-common mariadb-server

Modify /etc/apt/sources.list.d/mariadb.list

apt install mariadb-client mariadb-common mariadb-server

Run:

github.com

hestiacp/hestiacp/blob/58ba3a0b8013e751f50a334eb94637af6c43f545/install/hst-install-ubuntu.sh#L1554-L1569

      
        
            # Securing MariaDB installation
            mpass=$(gen_pass)
            echo -e "[client]\npassword='$mpass'\n" > /root/.my.cnf
            chmod 600 /root/.my.cnf
            
            
# Ater root password
            mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '$mpass'; FLUSH PRIVILEGES;"
            # Allow mysql access via socket for startup
            mysql -e "UPDATE mysql.global_priv SET priv=json_set(priv, '$.password_last_changed', UNIX_TIMESTAMP(), '$.plugin', 'mysql_native_password', '$.authentication_string', 'invalid', '$.auth_or', json_array(json_object(), json_object('plugin', 'unix_socket'))) WHERE User='root';"
            # Disable anonymous users
            mysql -e "DELETE FROM mysql.global_priv WHERE User='';"
            # Drop test database
            mysql -e "DROP DATABASE IF EXISTS test"
            mysql -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%'"
            # Flush privileges
            mysql -e "FLUSH PRIVILEGES;"

If you need phpmyadmin / roundcube make sure to add the database / users again