1

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

Improve this question
1
  • To clarify, the MySQL version is 5.7? MariaDB should be able to run on a Users table. If you look at show create user in MySQL output that should be transferable. log_builtin_as_identified_by_password=ON may be needed. Did you take the mysqldump with MySQL or MariaDB's mysqldump executable? If you have time online help might be able to assist.
    – danblack
    Commented Sep 12, 2023 at 23:35

1 Answer 1

Reset to default
0

Perhaps you can dump the users and their grants separately

I wrote a post about this Mar 24, 2013 : MySQL export user with semi-colon ";" on the end

What you do is dump all databases EXCEPT the mysql schema.

Load the grants dump into MariaDB and test connectivity. Then proceed with loading your data.

NOTE : I recently had an issue with a view in MySQL being ported to MariaDB. The SQL syntax of a query inthe view had to be changed. Please be onthe look out for that.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.