Forum Discussion
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
1 Reply
The error conflicts with the current geo-restore interface: documented az mysql flexible-server geo-restore has no administrator-password argument, and the portal creates a new server from the source backup. Do not add an undocumented switch or put a secret on the command line. Update Azure CLI, then rerun the documented command with target name, resource group, location, and the source server’s full resource ID. Confirm geo-redundant backup was enabled and the destination is a supported paired region. Run once with --debug and record the operation or correlation ID, redacting tokens before sharing logs. Since the same validation fails from CLI and portal, this likely indicates a service-side validation or resource-state problem, not missing input. Open an Azure support request with those IDs and regions. After restore, review networking, alerts, logins, and application connection settings separately.
