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

Raman Muthukrishnan 20 Reputation points
2024-09-04T00:15:33.9466667+00:00

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://video2.skills-academy.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 **
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
812 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,663 questions
0 comments
Accepted answer
  1. ajkuma 25,781 Reputation points Microsoft Employee
    2024-09-10T19:42:16.5366667+00:00

    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.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Raman Muthukrishnan 20 Reputation points
    2024-09-04T18:43:21.98+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.