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
<a href="https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-load-dump.html" data-type="URL" data-id="https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-load-dump.html" target="_blank" rel="noreferrer noopener">util.dumpInstance()</a>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
<a rel="noreferrer noopener" href="https://github.com/lefred/mysqlshell-plugins/wiki/user" data-type="URL" data-id="https://github.com/lefred/mysqlshell-plugins/wiki/user" target="_blank">user</a> plugin for MySQL Shell available on GitHub.
If you are interested, this is how it works: