Backup and restore the Azure Database for MySQL flexible server

Hi everyone,

I’m running into an issue while performing a geo-restore for an Azure MySQL Flexible Server using Azure CLI and Portal. 

When executing the az mysql flexible-server geo-restore command, the restore process fails with the error “InvalidAdminLoginPassword: The AdministratorLoginPassword cannot be empty or null”. I don’t see any administrator password configuration option in the Azure Portal, and there is also no auto-populated argument in the CLI. According to the official documentation, geo-restore uses the source server as the restore point, so the administrator login configuration is expected to be derived from the source server. Are there any recommended best practices for handling admin credentials securely during geo-restore? Thanks in advance for your insights.

I used this official doc as a reference, https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-portal