Rocky 8 Migrate MariaDB 10.5 to MySQL 8.0

carbon mariadb to mysql image
                        
                            mysqldump -u root -p mattermost > mariadb_dump.sql
 
                            systemctl stop mariadb
                            dnf remove mariadb
                            dnf module reset mariadb
                            dnf install mysql
                            dnf install mysql-server
                            cd /var/lib/mysql
                            mv mysql mysqlback
                            mkdir mysql
                            chown mysql:mysql mysql
                            systemctl start mysqld

                            mysql -u root -p
                            create user 'mattermostuser'@'%' identified by 'Password';
                            create database mattermost;
                            grant all privileges on mattermost.* to 'mattermostuser'@'%';
                            show databases;

                            mysql -u root -p mattermost < /root/mariadb_dump.sql
                            mysqladmin --user=root --password="" password "Password"