I am trying to migrate an Ubuntu 18.04-Server with Oracle's MySQL to a Ubuntu 22.04-Server with MariaDB 10.6.12. I've established a replication between the databases, which worked. Alone, the User management is entirely broken. Because Users are not longer a table but a view, the restore of the Mysqldump broke the original mariadb user view and created a table instead. Of course now almost all user accounts are broken.
How is the intended migration path for mission-critical Systems? I cannot afford significant downtimes, because that's why I create a replication during the migration process. Especially the passwords are an issue, as I cannot decrypt the original passwords (at least I hope so), so I cannot create the new Users with the CREATE USER statement. Whats the trick here?
Thank you very much, t2m