As part of migrating wordpress from AWS to Azure, unable to import mysql sql as phpmyadmin cannot login

Question

Hi Azure,

I setup a Wordress web app service. I am migrating wordpress site from AWS to Azure. I exported the SQL file from our old site in AWS. To import it into Azure wordpress, the instruction was to start phpmyadmin. Phpmyadmin asks for login details, and the mysql credentials that the Wordpress app showed when the service was created does not work. Would you kindly help? I followed the instructions in the article below:
https://learn.microsoft.com/en-us/azure/app-service/migrate-wordpress

and I am stuck in step 6.

1. If you migrate the database, import the SQL file downloaded from the source database into the database of your newly created WordPress site. You can do it via the PhpMyAdmin dashboard available at **

Answer 1

Following-up from the comments section, to benefit the community summarizing the issue and solution.

Scenario:

Migrating a WordPress site from AWS to Azure. Exported the SQL file from your old WordPress site hosted on AWS. To import this SQL file into the new WordPress site on Azure, need to use phpMyAdmin. However, encountering an issue where phpMyAdmin is asking for login credentials that do not match the MySQL credentials provided by Azure.

Ask:

Import the SQL file from your AWS-hosted WordPress site into the MySQL database of your newly created WordPress site on Azure using phpMyAdmin.

Issue:

When attempting to access phpMyAdmin on Azure to import the SQL file, prompted for login credentials. The MySQL credentials provided by Azure do not seem to work, and so unable to proceed with the import process. Referred : The instructions from the Azure migration guide but stuck at step 6, which involves importing the SQL file via phpMyAdmin.

Answer shared by Raman Muthukrishnan

Solution :

Since only Entra ID authentication was enabled, so unable to login with MySQL credentials.
With MySQL authentication enabled, able to login into phpmyadmin. Referenced YouTube tutorial by Azure Database for MySQL.

---

> please click Accept Answer - it will benefit the community/users to find the answer quickly.

Answer 2

The below youtube video answered my question. Since only Entra ID authentication was enabled, I was unable to login with MySQL credentials. With MySQL authentication enabled, I was able to login into phpmyadmin.

https://youtu.be/YldN5WkQCco?si=LTpLwvLrKPTco1ct