How to copy a MySQL user to OCI MDS ?

When you migrate to MySQL Database Service on Oracle Cloud Infrastructure (MDS on OCI), the easiest, fastest and recommended way it to use MySQL Dump & Load Utility.

For more information check these different links:

MySQL Shell performs all the checks required also for copying users to MDS when using util.dumpInstance()method.

This is the safest way to migrate data to MDS as when the ocimds option is enabled, you have the possibility to skip accounts which use authentication methods (plugins) not supported by the MySQL Database Service but also to remove certain privileges that are restricted in the MySQL Database Service.

But sometimes you may only want to copy a user (or some) to one server to another one. And that destination server can also be a MDS instance.

Therefore, I’ve added a new method the the user plugin for MySQL Shell available on GitHub.

If you are interested, this is how it works:

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

You can find articles I wrote on Oracle’s blog.