On MySQL Database Service (aka MDS) on Oracle Cloud Infrastructure (aka OCI), when you create a new instance, you also need to set the credentials for the administrator:
Let’s focus on that account…
Please don’t forget the password, it cannot be recovered !!
First of all that account’s username has some limitations. Indeed, some names are reserved as it’s mentioned in the manual. So you could not use the following usernames:
- administrator
- ociadmin
- ocirpl
- mysql.sys
- mysql.session
- mysql.infoschema
This list can evolve, you can get the list directly from the MySQL DB System creation’s screen:
In fact, those accounts are already existing in the MySQL DB …
[Read more]